Hello,
Is it possible to export DTS to another SQL Server?
Sure it's possible. In SQL2000, you can follow these steps:
1. Open Enterprise Manger, select the source SQL instance, explore 'Data Transformation Services'->'Local packages', double click a DTS package to design it.
2. In the Design UI, click 'Package' menu->'Save as', chage the 'Location' dropdown list to 'Structured Storge File', and give a name to the .dts file (e.g. c:\test.dts)
3. Select the destination SQL instance, right click 'Data Transformation Services'->'Open Package', select the .dts file you just saved to file system.
No comments:
Post a Comment