How to Transfer DTS Package

[glkrause]

I have a complicated DTS package to develop off site and want to transfer it to a clients site when complete. How can I go about this?

Thanks.

 

[MAK9974]

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']

 

[TerryStover]

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.