Post reply

Execute DTS from Visual Basic

  • November 27, 2002 at 9:06 am

    #151769

    I originally posted this in the security forum but should be here.

    I am attempting to create a procedure that executes a DTS package from a VB app. The package was initially created by another one of our administrators and the owner is listed as his NT Username. If I run the procedure from my machine, or any other machine that I am logged in to, VB app works fine and the package is executed, but if one of our regular user's tries to run the procedure the package will not execute.

    Here is the code that I am using:

    oPackage.LoadFromSQLServer "Servername", "sa", "password", 0, , , , "Package Name"

    I belive that this must be some sort of permissions issue and that is why I was using the sa account to try and execute the package.

  • November 27, 2002 at 4:38 pm

    #442590

    Check out

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

    It gives some explanation about the security issues when running pacakges.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

  • November 28, 2002 at 9:18 am

    #442633

    I have found that the DTS actually runs using the NT Account of the user and not the login and password supplied in the LoadFromServer method. I had to ensure that the user had the correct permissions for the tables that were being affected by the DTS.

    Everything works fine now. Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply