Post reply

Executing a DTS using Visual Basic

  • August 7, 2003 at 1:40 pm

    #59300

    I have written a Visual Basic program that allows a user to execute a SQL Server DTS process. The program works fine as long as SQL Server is on the same computer

    I want to know if it is possible to execute this same SQL Server DTS VB program from a computer that does not have SQL Server on it, and if so how?

  • August 7, 2003 at 1:43 pm

    #469082

    Look at http://support.microsoft.com/default.aspx?scid=kb;en-us;315661 and http://support.microsoft.com/default.aspx?scid=kb;en-us;323685

  • August 8, 2003 at 4:34 am

    #469158

    You didn't say which version of Visual Basic that you were using. If you are using Visual Basic .NET, the problem is a "rights" issue. The user that is logging onto the SQL Instance must have "login' rights to the physical server not just the SQL instance. Add them as a member of the "users" that may log onto the server.

    If you are not using the .NET version, the solution is different.

  • August 8, 2003 at 2:09 pm

    #469243

    I've found that installing this files you could execute your VB DTS program.

    * AXSCPHST.dll

    * Custtask.dll

    * DTSFFile.dll

    * DTSPkg.dll

    * DTSPump.dll

    also you must copy the 1033 folder where you copy and register these files.

    For register those files use regsvr32.

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

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