Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    5

    Unanswered: 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?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to this SQL DTS link.

    Or you can use COPY DATABASE wizard to accomplish the task.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •