Post reply

DTS and the dll''s

  • April 4, 2006 at 10:22 am

    #171154

    Hi everyone,

    I have a VB6 application that triggers a DTS. The problem is the software we use (WinCC) has SQL Server with it. So this is only on the server.

    I need to allow the client nmachines, which have a VB executable to trigger the DTS. But these clients machines are missing the dts dll files.

    And I get an error message back. I tried registering these files with REGSVR32 but that doesnt work. Is there anyother way of doing this?

  • April 4, 2006 at 12:27 pm

    #630786

    Gerard,

    Take a look at this link and see if it helps.

    http://www.sqldts.com/default.aspx?225

    Good Luck,

    Darrell

  • April 5, 2006 at 3:59 am

    #630931

    Hi Gerard,

    As an alternative to installing the SQL Server DLLs, the approach Ive used is to create a "wrapper" DLL to execute DTS packages.   This is really just some helper code to make it easy to run a specified DTS package, set/read global variables etc.   

    Put this DLL in a Server COM Application on the Database Server, then setup a proxy on the middle-tier/client machine.    This gets around having to install any extra stuff on the client, and also you could setup the COM component with impersonation to ensure so you dont have to give individual users/groups permissions on the database, and finally maybe use COM+ Roles to restrict access to the wrapper DLL.   Well, something like this.

    Hope this helps?

  • April 5, 2006 at 6:12 am

    #630946

    If you have source code and ability to modify/recompile your program, you could consider having your code raise an error on the SQL server with a specified error number. You can configure SQL to run the DTS package every time that error is raised. There are some good articles on that elsewhere on these forums.

  • April 5, 2006 at 9:34 am

    #631044

    Thanks for all the advice lads!

    I have pasted the dll's dtspkg.dll and dtspump.dll into C:\WINDOWS\System32 folder and thanks to link at top I pasted the two resource files dtspkg.rll, dtspump.rll into a folder I created

    C:\WINDOWS\System32\Resources\1033

    and now using REGSVR32 I.E. C:\>REGSVR32.EXE DTSPKG.DLL, actually succeeds. Now I have yet to try this on site but I am hopeful.

    If any of you can see obvious problems or dangers with this please let me know - Again thanks for all the help!

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

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