Help on DTS Export

Question

Help on DTS Export

CDBA

Hall of Fame

Points: 3266
More actions
October 27, 2006 at 8:43 am

#68454

Hi,

I need a help. I need to archive some DTS packages from our SQL Server. But instead of storing them as a complete backup of MSDB, customer prefers to store them out side of SQL Server so that they can import it back any time. [Like .dtsx in 2005 environment]. Is there any way to export the DTS from SQL Server to a file system or if there is some other way to achive the goal?
Many thanks in advance.

Regards
Utsab Chattopadhyay

CDBA

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

lucky-80472 SSCertifiable Points: 7793 More actions · Answer 1

Hello Utsab,

You can save the DTS package as a file. Open the particular DTS package and in the DTS designer, click on Package -> Save As

Now you will be prompted with another screen "Save DTS Package". Here change the location to "Structure Storage File". The file will be saved as .dts.

If you want to restore it back on any server, then click on "Data Transformation Services" under the desired server and select "Open Package..". Here you will be prompted for the location of your saved .dts file.

Hope this helps.

Thanks

Lucky

Greg Charles SSC-Forever Points: 45403 More actions · Answer 2

If you have a lot of packages to save, I've found a great, free tool that will save or transfer multiple packages. This saves you the effort of opening each package and saving as a file. It's called DTSBackup 2000 and it's downloadable from http://www.sqldts.com.

Greg