I am rather new to DTS, I apologize if this has already been covered
elswhere in the group - I couldn't find it.
I am trying to create a package to transfer an arbitrary number of
tables from one database to another on the same server. The criteria
is to transfer all user tables with names beginning with "SC". They
are to be dropped in the destination databse if they exist, and
re-created, all data to be transferred from source. The trick is that
I may have any number of such tables at any given time.
Can anyone assist with this? Maybe include a code sample I can use and
customize?
Greatly appreciate any help you can give.

Hello aksenenko (AT) gmail (DOT) com,


This is probably best not suited to DTS (Although it can be done)

I would look to use SQL DMO to get my tables and their scripts, I would then
look to see if the destination object existed and drop or create from there.

I would then transfer the data.


Allan