DTS packages
-
I am using sql server to copy data from oracle. So I use DTS to copy a table. What I have done is use DTS Import/Export Wizard. And I have DTS packages which is schedule every day to update table. But the problem is all the data repeats in my new table in sql database instead of updating data. Please give me some hint what I can do? and where can I go to learn abt it. Thank you very much. sudeep ====== Yo need a brain to code.
-
I am using sql server to copy data from oracle. So I use DTS to copy a table. What I have done is use DTS Import/Export Wizard. And I have DTS packages which is schedule every day to update table. But the problem is all the data repeats in my new table in sql database instead of updating data. Please give me some hint what I can do? and where can I go to learn abt it. Thank you very much. sudeep ====== Yo need a brain to code.
You could add another SQL task to your DTS package which would execute a "TRUNCATE TABLE " before your datapump step.