DTS Package problem in VB.Net
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
Re: DTS Package problem in VB.Net
Try using the appropriate security flag:
Code:
pkg.LoadFromSQLServer("TEST1/TESTBED", "sa", "password", DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, , , , strPackageName)