SQL Server Performance Forum – Threads Archive

executing DTS from VB program

Hi, I have a VB.NET app who call a DTS on a remote SQL Server. My application sets a few global variables and call the execution. But it failes every time. When I execute the DTS directly in SQL Server with the global variables set with the same values, it run fine. To set the GV, I remove them, set the new value and put them back in the DTS. The DTS, when called from my app seems to take the path to some files needed by the DTS, localy from the computer who run the app , instead of taking the files directly on the server, so it’s why it crash. Is there any "rules" to call a DTS on a remote server from a VB.NET application?? thanks for your tips, Dominic

Refer the following links for relevant information:
http://www.sqldts.com/default.aspx?264
http://www.vbdotnetheaven.com/Uploa…rticleID=b84515dd-f8aa-4790-a1c6-0738964492f6
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=209389 Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

thanks for the reply and the links, I’ll check it out

Also look for dtsRun in SQL Server help file Madhivanan Failing to plan is Planning to fail

]]>