sql server dts: Is there a way to load a package from a structured file, in a different
server than the one it was saved from, and then save it back to the same
structured file as a new version under the same package ID?

When I save a package to a DTS file, it has a package ID and each save from
the same server results in different version_ID's within that package_ID.
If I load that package on a different server and save it back, it is saved
with a new package ID. The result is a structured file with 2 identically
named packages, when I would like to see a newer version with the old package
ID.

The problem this causes is that my support team can't make "emergency fixes"
to production jobs unless they also use the "development" servers and know
which server the package originally came from. They can theoretically do the
fix and save it back, but the production wrapper package or scheduled job is
still loading the original package ID, so is not picking up the fix.
--
Thanks and Good Luck.
Fergus

Hello Fergus,

Thank you for using Microsoft newsgroup. I understand that you'd like to
load a package from a structured file in a different serve and then save it
back to the same file with a new version of same packageI ID. If it is
incorrect, please let me know.

Based on my test, I was not able to reproduce the what you described:

1. created a DTS package in one server, and saved it to a structured file.
Used dtsbackup 2000 tool to check the packageId/versionID

2. Load the DTS package (from file located on the original server) on
another SQL Server, removed an item and saved it back to the folder. Used
dtsbackup 2000 tool to check the packageid/versionid and packageid was not
changed but there are 2 versions

For more information about DTSpackage 2000, please refer to the link below


http://www.sqldts.com/default.aspx?272

Note: This response contains a reference to a third-party World Wide Web
site. Microsoft is providing this information as a convenience to you.
Microsoft does not control these sites and has not tested any software or
information found on these sites; therefore, Microsoft cannot make any
representations regarding the quality, safety, or suitability of any
software or information found there.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Fergus,

Just want to check if you'v tried the steps and if the issue still occurs.
If you have any questions, please let me know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.