[RESOLVED] Transferring a Data Transformation Services (DTS) - Local Package to another Server

Recently we moved our MSSQL7 data from one server to another. Every thing went fine but I now need to transfer the a few Data Transformation Services - Local Package from the old server to the new one. Does anyone have any information on how I might go about doing this?

Thanks

The only way I know is to export them with Enterprise Manager in Sql Server 2000.

What you have to do, is edit the package, click on the save button and in Location, choose Structured Storage File, instead of the SQL Server option.

A save as dialog will appear and you have to save the package as DTS.

HTH
HoraShadow

Quote:

---

Originally Posted by HoraShadow

The only way I know is to export them with Enterprise Manager in Sql Server 2000.

What you have to do, is edit the package, click on the save button and in Location, choose Structured Storage File, instead of the SQL Server option.

A save as dialog will appear and you have to save the package as DTS.

HTH
HoraShadow

---

Will that work with MSSQL7, I didn't see that option.

I figured it out, if you open the DTS package Under the Package Menu Item there is a Save As option. I just saved it onto the new server and it worked like a charm.

Thanks!