MS SQL> How to save DTS Package?

[stefan_furlan]

Hello!

I'm trying to save DTS Package from SQL Server to Structured Storage File WITH metadata?

i used dtsrun:
DTSRUN.EXE -S "SERVER" -E -N "DTS PACKAGE" -F "C:\TEMP\DTS PACKAGE.DTS" -!X
but saved package does not include metadata (i loose object positions, connections are doubled, i loose text descriptions, ...)

Do anybody knows how to save Package that would include metadata (like if saved manualy from SQL Enterprise Manager console)?

Thanks,
Stefan Furlan

[skhanal]

I don't think you can use DTSrun.exe to save a package, this is for executing the package.

[stefan_furlan]

You can...
The result is not what i would like

try command:
DTSRUN.EXE
-S "SERVERNAME"
-E
-N "PACKAGENAME"
-F "C:\TEMP\PACKAGENAME.DTS"
-!X

This command takes package PACKAGENAME from Sql Server Repository and saves it to file C:\TEMP\PACKAGENAME.DTS and does not execute it (-!X).


Try that. Then open the saved file. You will see the diference between file saved with DTSRUN and file saved manuali from Enterprise Manages console.

[skhanal]

I see this in books online for !X

/!X

Blocks execution of the selected DTS package. Use this command parameter when you want to create an encrypted command line without executing the DTS package