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] "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:jsdrl092e25ghdg4430qemgpf022qcp07t@4ax.com...
> 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@hotmail.com (Bill S.) 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@nomail.please> wrote in message
>>news:<t0gpl0p3sunsg3gh694a820tqtkutf1c98@4ax.com>...
>>> 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@hotmail.com> wrote:
>>>
>>> >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
>>> >
>