How to transfer DTS from one computer to other?
I have a DTS package runing on one server1. I need to transfer this DTS to some other server2. But these two servers are on the different network. Hence temme the way to transfer it to server2.
Thnks,
Rahulopen that DTS and click save-as, select Structured-Storage-File as location. a disk file will be generated. this can be imported to the new server by right click on Data-Transformation-Services and selecting Open-Package. after opening save by selecting SQL-Server as locationsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment