Transfer tables from one server to the other on a regular basis. I'm doin this using the DTS import wizard (saved it as a package and scheduled a job). But i noticed that if the table structure changes on the soruce tables, the DTS package will fail.
I want to make a DTS package that imports 6 tables, now how do i make it such that if the structure of the tables changes it shud still work. ie, everytime the tables are tranferred, the old tables on the target server must be dropped and re-created with the source server table definition. I hope this is doable.
but if the package runs regularly.. and one of the many times, the tables' being transferred structure changed. how the heck is the EXECUTE SQL Taks gonna know bout this?
is there a way to dynamically get the table structure from the source server?!