Results 1 to 4 of 4

Thread: DTS Package problem in VB.Net

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Nov 2004
    Posts
    16

    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

  2. #2
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Leavenworth KS USA
    Posts
    482

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Nov 2004
    Posts
    16

    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

  4. #4
    Fanatic Member vb_dba's Avatar
    Join Date
    Jun 2001
    Location
    Somewhere aloft between the real world and insanity
    Posts
    1,016

    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
  •  



Click Here to Expand Forum to Full Width