you can save the DTS package in "Stuctured Storage File" [option- Save as and change the location to 'Stuctured Storage File']
and take it to client and load it into the client site
[Right click on 'Data Transoformation Services' - click 'open Package']
You will probably need to reenter the data source security information. If you are using odbc you need to set up the same dsn's on the target server. When it asks do you want to reset the transformations, say no, otherwise they'll all get wiped out.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.