DTS - how to backup and restore the DTS script?

I recently started to use DTS to do some of my database maintenance works. May I ask how do I backup those DTS scripts and how do I import them back?

I can find the "Save As..." function and it allowed me to save the script to bas or dts file. But I cant seem to find any function for me to restore that saved file to the SQL Server.

Please help.I got this from a Microsoft support Webcast, "It really depends on where you're storing your DTS package. If the package is stored as a file, if you store it on MSDB, backing up to MSDB would take care of it." The second link is from Darren Green SQL Server MVP. Hope this helps.

http://support.microsoft.com/?scid=http://support.microsoft.com%2Fservicedesks%2Fwebcasts%2Fen%2Fwc120500%2Fwct120500.asp

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

Kind regards,
Gift Peddie|||You can import a dts package by right clicking on data transformation services on left side of the screen. Then you click on the option 'Open package'. In the next screen you can select the package.|||

Hi,

That's OK that we can open the package and work on it and will save the package. BUT when we save the package it's not saving in the SQL server its saving in the same file,

So i want that How to get that file in my sql server so that i will not open and work on the file again and again. If i'll got this package in the sql server then i'll not need to open this DTS file again and agian. So how to do this.

the basic i want to ask abt DTS is.. HOW TO BACKUP DTS AND HOW TO RESTORE DTS.?