executing DTS from VB program | SQL Server Performance Forums

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.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=209389 Satya SKJ
Contributing Editor & Forums Moderator
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