I have about 20 DTS packages that copy tables unchanged from one server to another. I do this because sometimes some of these tables may not be populated which will cause me problems with the web pages based on their content. I have a script which checks the existence of data in these tables before allowing the transfer task.
I am thinking it may be better to use the Copy SQL Server Objects tasks - certainly for ease of maintenance.
Is it possible to:
1 test the existence of each table being copied in this task before allowing it to continue
2 Does the task move on to the next table and copy it if it fails with one or more tables?