|
-
Nov 5th, 2004, 03:42 PM
#1
Thread Starter
Junior Member
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
-
Nov 5th, 2004, 06:40 PM
#2
Hyperactive Member
-
Nov 8th, 2004, 11:39 AM
#3
Thread Starter
Junior Member
same error...
I am still getting the same error.
"Login Failed for user TESTBED/GregJ"
In the LoadfromSQL Server statement, I clearly specify a username and a password. Why would it be trying to login as TESTBED/GregJ.
I noticed the error happens when I actually execute the package, not when I run the loadfromsqlserver statement. Is there something I am missing?
Well, I hope I can get some help. I am still pretty new at this stuff.
Thanks
Greg
-
Nov 9th, 2004, 07:51 AM
#4
Fanatic Member
Re: DTS Package problem in VB.Net
Try using the appropriate security flag:
Code:
pkg.LoadFromSQLServer("TEST1/TESTBED", "sa", "password", DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, , , , strPackageName)
Chris
Master Of My Domain
Got A Question? Look Here First
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|