I am working on a complicated DTS package to transform data. Certainly I am working on a testing server since I do not want to interrupt the production server. However, I do not know how to copy the DTS package to the production server after the DTS package on the testing server is done. Do I have to redo the whole process of building a DTS package on the production server?
By the way, I know I can save DTS package as a VB file or a meta data package. What are those "saving" function for? Can I load these packages to anther server?
Thanks in advance.
Seaport
By the way, I know I can save DTS package as a VB file or a meta data package. What are those "saving" function for? Can I load these packages to anther server?
Thanks in advance.
Seaport