all groups > sql server dts > september 2004 >
You're in the

sql server dts

group:

Copying packages to another server


Re: Copying packages to another server Sue Hoegemeier
9/30/2004 8:28:13 PM
sql server dts:
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"
[quoted text, click to view]
Copying packages to another server JC
9/30/2004 9:02:02 PM
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

Re: Copying packages to another server bill_sheets NO[at]SPAM hotmail.com
10/1/2004 7:45:10 AM
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


[quoted text, click to view]
Re: Copying packages to another server Sue Hoegemeier
10/1/2004 2:02:23 PM
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

[quoted text, click to view]
Re: Copying packages to another server Allan Mitchell
10/2/2004 12:04:59 PM
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


[quoted text, click to view]

AddThis Social Bookmark Button