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

[Mark Gambo]

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

[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

[Mark Gambo]

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.

[Mark Gambo]

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!