Sunday, February 19, 2012

Bulk Edit DTS Packages

I have a Whole Bunch of DTS packages that copy data from Database1 to Database2.
I want to quickly make duplicates of all these packages, except that they will copy data from Database1 to Database3. Everything else stays the same.
Is there an easy way to do this?Refer to this SQL DTS (http://www.sqldts.com/default.aspx?6,105,204,0,0) link.

Or you can use COPY DATABASE wizard to accomplish the task.

No comments:

Post a Comment