SQL Server Performance Forum – Threads Archive
DTS Package GUID
Hi, I have stored procedures that are executing DTS packages using the dtsrun utility usingdtsrun /S /N /G where /G is the package GUID. The package GUID is hardcoded in the stored procedures. Now, when I move the database and the DTS from one environment to another, I export the DTS as .dts file and save it on the target server. Does the GUID change when this is done ? Because, I looked in msdb..sysdtspackages table and saw that the ID is different than what is hardcoded in the stored procedures. I would appreciate if some one has suggestions to offer. Thanks in advance.
Yes the GUID is system generated and when you restore or export to other server, it will be changed. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thank you Satya
]]>