>Hi,
>
>I 've developed DTS packages on a SQL Server 2000
>database. How to deply easely these package on other
>server, without enter in each package to record the nex ID
>on each sub package etc.
>
>Thank you for answers.

>-----Original Message-----
>In article <0a3e01c36cbe$8feb89b0$a001280a@phx.gbl>,
TOMASSONI
><tomassoni@sungard-finance.fr> writes
>>Hi,
>>
>>I 've developed DTS packages on a SQL Server 2000
>>database. How to deply easely these package on other
>>server, without enter in each package to record the nex
ID
>>on each sub package etc.
>>
>>Thank you for answers.
>
>You are having problems with the changing package GUID as
referenced by
>the Execute Package Task?
>
>You can fix the task like this-
>
>Make the Execute Package Task name dependent only
>(http://www.sqldts.com/default.aspx?216)
>
>
>Or
>
>Do not use the Designer or DTS object model to do the
load and Save As,
>transfer packages directly between the servers, or rather
sysdtspackages
>tables, as this means the GUID and version ID stay the
same.
>
>Transferring DTS Packages
>(http://www.sqldts.com/default.aspx?204)
>
>
>DTS Backup has a direct transfer option for certain
storage methods
>(Under Options) which odes this, but also has it's own
file format to
>allow a file stage in between two servers
>
>DTSBackup 2000
>(http://www.sqldts.com/default.aspx?242)
>
>--
>Darren Green (SQL Server MVP)
>DTS - http://www.sqldts.com
>
>
>.