Hi,

When I copy my DTS packages (in the .DTS format) from my
developpment PC to my production Server and then re-create
the packages on the server, I have a problem with the
package which synchronizes the other packages : The Ids
referenced by it are no longer valid (since the packages
have been re-created), so I have to re-select each package.
Has anyone a solution so that the link would be kept, as
long as the name is correct ?

Thank you for your help

Benoit

The action of Save As creates a new package, hence a new package GUID, not
just a new version.
Two methods-

Stop referencing the package by GUID, just use the name. There is no reason
to use the GUID unless your own business/development processes use this for
consistency.

Transfer the packages via an alternative method, such as copying between the
sysdtspackages system tables.

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)

--
Darren Green
http://www.sqldts.com


"Benoit" <anonymous (AT) discussions (DOT) microsoft.com> wrote

What we did was editing packages that have other package references in the
disconnected mode removing all package IDs and version IDs from Execute
Package Tasks. This let us reference the latest package version by its name,
not ID. It is the same as executing a package through DTSRUN specifying only
a package name. Be careful not to execute a package on a different server by
accident if it has the same name and you specified the server incorrectly.
Package ID was the protection in this case.

Ilya

"Benoit" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Concerning your 1st method... I don't see what you mean,
even if I select a package using its name, it stores the
guid !

Anyway - I used the 2nd method and it works great, since
it copies the packages without changing the IDs.

Thanks for your help.

In message <408c01c401d5$a8353e60$a601280a (AT) phx (DOT) gbl>,
anonymous (AT) discussions (DOT) microsoft.com writes
A package will always have a GUID, but you do not need to load the
package by the GUID. Your load method must specify a GUID hence the
problem, so change the load to not use the GUID. You haven't actually
given any details of what the load method is otherwise I could be more
specific, but for example DTSRUN does not need the /G parameter, as /N
will suffice.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org