Running a DTS package from VB.Net

smithygreg

New member
Joined
Nov 5, 2004
Messages
1
Programming Experience
1-3
Hi all...
I am trying to run a DTS package on SQL Server 2000 from VB.Net

pkg.LoadFromSQLServer("TEST1/TESTBED", "sa", "password", , , , , strPackageName)
pkg.execute()

When the package tries to do anything, I get the error
"Login Failed for User TESTBED/GregJ"

GregJ is the name of the computer I am running the vb program from. I would assume that I was trying to log in as "sa", not "GregJ"...
Any help is appreciated.
Thanks All
Greg
 
Top Bottom