Hello NG,

importing a DTS package that has been saved as a structured storage file
is easy, if the SQL Enterprise Manager (Right click on 'Data Transformation
Services', 'Open Package') is used.
It does not seem to be so easy, if this activity needs to automated. I
currently use the tool 'DTSBackup2000Cmd.exe' for it, but this tool has the
major disadvantage to completely corrupt the graphical design of the package
(which is a serious maintenance problem, if the package contains more than
fifty objects with complex process flow arrows between them).
Does anyone happen to know if there is a better tool for this activity,
or, even better, if the SQL Server offers a functionality for (scriptable)
export/import of DTS packages as structured storage files?

Thank you in advance! Chris

Hello Christian,



the util "DTSBackup2000Cmd.exe" probably (surely) uses the DTS objrce model
which implements the interface method _package2.SaveToStorgeFile(...). I
built some tools to automate some operations on packages on storage-file
and, once saved the package using the object model, i always had layout
information compromised, just like you and i've never been able to find a
workaround...