Tuesday, March 20, 2012

script of dts?

hello, its possible make a sql script of a dts to install the dts in
other sql server instance?Yes, the easiest way is to open the package. Then under the package
menu option, select save as. This will give you a dialog box with
options on how you can save it. You can save it directly to your other
SQL Server, or if you need this included in a deployment plan of some
sort, then you should save it to a file. Your options for saving are
in the "Location" dropdown. Hope this helps.

No comments:

Post a Comment