var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to copy the DTS Package from one server to another?
I have created some DTS packages in my sql server now i want to copy them to some other SQLServer. Is it possible to do that? If so pls help me to do that.
When saving, choose "Save As" and then change "Location" to "Structured Storage File" instead of "SQL Server".
That will give you a file.dts that you can transfer and load onto another SQL Server.
(To open it on a target server, place yourself on "Data Transformation Services" in EM, and right-click the mouse on right blank field. You'll see "Open Package" in pop-up menu
Is there any other way?
Thanks for your reply. but I know this method. Is there any other way to do this?. Instead of creating seperate dts files i want to eport all of them at one shot. same like import/export database.
If any one knows pls help me.
Well, maybe try to copy msdb ?
Or just transfer msdb's tables that are related to DTS ?
The same explained in detail