DTS

Can you script a DTS package?
Or is there another way to copy a DTS package from one server to another (i.
e. from testing to production)?
Please let me know ideas.
Thanks!Yes. When you click Save As, change the location from SQL Server to either
of the other two options... Then you can save it as a file and copy it
wherever you want. To open the file, right-click on Data Transformation
Services in EM and click Open Package...
"Ysandre" <ysandre@.hotmail.com> wrote in message
news:C4B4662C-C87E-409B-85D3-20732A0ADB85@.microsoft.com...
> Can you script a DTS package?
> Or is there another way to copy a DTS package from one server to another
(i.e. from testing to production)?
> Please let me know ideas.
> Thanks!|||On Fri, 14 May 2004 09:46:01 -0700, Ysandre wrote:

> Can you script a DTS package?
> Or is there another way to copy a DTS package from one server to another (
i.e. from testing to production)?
> Please let me know ideas.
Just save it as a file and then import it to the production server.
Morten Isaksen
http://www.aub.dk/~misak/|||Thanks! That's exactly what I was looking for.
I figured out the save as structured file part, but couldn't find the instru
ctions on what to do with it after that!
Thanks again!
Have a great weekend.