June 9, 2005 at 1:30 am
Hi there.
I wonder if there is a method to copy multiple DTS-tasks in the DTS-designer. I can easily copy 1 task, I have in mind copying a complete workflow of several tasks. What I do is setting up a copyprocess for tables from 1 server to the other, where the table to be copied is dropped and recreated on the targetserver. I have generated a package with the Importwizard,which seemd to me the easiest way to do this. Occasionally 1 or more tables are added or deleted, and it would be very convenient if I could just copy the whole proces of an existing table and change that, or even create a new package for the tables to be added with Importwizard and then copy the tasks or this new package to the existing DTS-package.
If there is a way to do this, I would really like to know.
Greetz,
Hans Brouwer
June 9, 2005 at 10:25 am
It sounds to me that what you really want is a generic package where you can specify source and destination objects as paramters and then run.
To do this you need to use the 'Dynamic Properites' task. There's some really good examples at http://www.sqldts.com.
This one will also give you a good start - http://www.databasejournal.com/features/mssql/article.php/3073161
Other than that, you are going to have to try to create the package using DMO. Unless you are an advanced programmer, this is will be a lot harder for you to do.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply