Is this possible. I don't see it as an option. I have some rather involved
transformations. I am moving the processing to another server and would hope
that I could copy the package and then change some of the settings and save
them on the new server. Can I do this?

John Cantley

Open the package in design view, go to the menu to Package
and then Save As. You can then chose the other server for
the server location.

-Sue

On Thu, 30 Sep 2004 21:02:02 -0500, "JC"
<striderguy56 (AT) hotmail (DOT) com> wrote:

I also need to copy a DTS package to another server, but the package
already exists with the same name on the other server. Saving it as
a different name really isn't an option, and I really do not want to
delete the current package on the destination server. What I really
want is for the copied version to just be the latest version of an
existing package.

Save As gives me this error:

DTS Package 'My DTS' already exists with a different ID in
this category.

Is there a way around this?

tia,
Bill


Sue Hoegemeier <Sue_H (AT) nomail (DOT) please> wrote

If you want to save it to another server where there is a package with
the same name and you don't want to delete the existing package with
the same name, I don't think there really is any way around that.

-Sue

On 1 Oct 2004 07:45:10 -0700, bill_sheets (AT) hotmail (DOT) com (Bill S.) wrote:

The only way I can possibly see you doing this is

DTS versions packages. It does this by simply adding rows to sysdtspackages
everytime you save any changes to the package.
Knowing this you can transfer the row from your Source Server's
sysdtspackages (for the correct version of the package) to the destination
server's sysdtspackages table. You can then rename the new row to the name
you require and also set the id property the same.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote