"Kris Kirk" <kriskirk@hotmail.com> wrote in message
news:2ea4783f.0307101429.42ec8dfc@posting.google.com...
> Hi,
>
> In the Execute Package task, is there any way of preventing the
> Package ID from being stored so that it is determined at runtime
> rather than design time?
>
> I want to execute a package by name and not ID because the package
> ID's can change when transferring packages between servers.
>
> I guess the alternative question is how to retain the original Package
> ID when transferring a package to a remote server. The way I'm doing
> the transfer is as follows:
>
> 1) Save the Package from the Source server to a .DTS file.
> 2) Open the Package on the Destination server.
> 3) Save the Package to SQL Server on the Destination server.
>
> Step 3 seems to generate a new Package ID and this is causing me
> problems when another package is dependent on it.
>
> Is there a better way of doing this?
>
> Kris