Hi,
I need some help from you guys. As part of my new job, I need to create a
DTS Package to syncronize the production and QA Databases.The steps to
follow are
Say for example the databases contains more than 100 tables and we need to
copy the contents of few tables (say tab1, tab2, tab3.... ) then
step1. rename those tables in the QA server (tabA_ + value of getdate())
step2. copy the tables to QA
I have no idea of DTS, i can solve this using T-sql, but I need the DTS
Package. Can anyone help in this thing.
I have already visited www.sqldts.com

regards Lara

Hello lara,

if you can solve it with just T-SQL you could simply use one or more ExecuteSQLTask
in your DTS.
Bye