I save a package in a Structured Storage file. Then I opened the saved
package with EM and tried to Save as . . into Sql Server. This failed with
"DTS Package 'Test package' already exists with a different ID in this
category." I have no idea what that means. And there is no 'Test package'
saved in Sql Server. Microsoft says you can use a Structured Storage file
to "move packages between platforms", but that does not mean it is a
mechanism to move a package from server to server. It appears that saving a
package as a Structured Storage file is a one-way trip! Is that true?

Thanks,
Micihael

You cane load and save packages as you describe, but the error is failry
straight forward. A package exists of that name already. If you run a
profiler trace you will see the procedures being called, and can even look
at the code where it throws this error.

Packages are stored in msdb..systdtspackages, so you could always do a quick
select * from sysdtspackages where name = 'Test Package'


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

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