To add to Simon's response, below is a VBScript code snippet that will copy
a package from a SQL Server repository to a structured storage file.
SqlServerName = "MyServer"
DtsPackageName = "MyPackage"
Set Fso = CreateObject("Scripting.FileSystemObject")
Set DtsPackage = CreateObject("DTS.Package2")
'get package
DtsPackage.LoadFromSqlServer
SqlServerName, , , 256, , , , DtsPackageName
'generate file name
DtsPackageFileName = "C:\MyDtsPackages\" & _
DtsPackage.Name & ".dts"
'delete file if it already exists
If Fso.FileExists(DtsPackageFileName) Then
Fso.DeleteFile DtsPackageFileName
End If
'create structured storage file
DtsPackage.SaveToStorageFileAs _
DtsPackage.Name, _
DtsPackageFileName
--
Hope this helps.
Dan Guzman
SQL Server MVP
"David Greenberg" <da*****@iba.org.il> wrote in message
news:40***********************@news.frii.net...
Hi !
I know how to save a DTS as a structured storage file and how to
recreate a DTS using that file.
What I can't find is a command, either in t-sql or from a DOS level,
with which I can save the DTS as a structured storage file, for example
in a scheduled job for backup purposes.
Hopefully some out there has an answer !!!
Thanks
David Greenberg
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!