Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: Error when VB runs DTS package

    Hi ,

    I am trying to run DTS package (stored on SQL Server) using Visual basic but i am getting the following error

    Runtime error '-2147217843 (80040e4d)'

    Login failed for 'MyUserID'


    *************************************
    i used the following code in VB program

    Sub Command1_Click()
    Dim dtsp As New DTS.Package
    dtsp.LoadFromSQLServer _
    ServerName:="MyServer", _
    ServerUserName:="MyUserID", _
    ServerPassword:="MyPassword", _
    PackageName:="DTSDemo"
    dtsp.Execute
    End Sub

    *************************************

    I can Run the package direct from SQL server but get error by Vb program. Any idea why it is so.

    Thanks

  2. #2
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    29

    Error when VB runs DTS package

    Please follow the article: Error when VB runs DTS package .. for a solution for the problem.

    Greetz,
    DePrins1968

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    29

    Oeps, made a mistake. Correction....

    What i ment was follow the article/post:

    "Trying to run DTS package from Microsoft Access"

    Greetz,
    DePrins,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •