asked
Help with Designing a package SSIS 2012
Dear all Can you please plz help me to implement SSIS package to do the following: IF I have a table name customer have columns :- id , name , address. first :- I need from the SSIS to copy the data to another destination call the cus_new table, after that I delete the data inside the customer. and when I add a new data in this customer I need to copy the new data to cus_new table. Second :- and If someone add new columns to customer table like salary I need from the SSIS to redesign the cus_new and add the new columns (id , name , address, salary) and add the data with the new design without losing the old data I'm using SSIS2012. ![alt text][1] [1]: /storage/temp/1152-tables.jpg
Moving the data is straightforward. Keeping the schema in synch requires a bit more work. From a process perspective, when "someone" adds a new column to the customer table, it sounds like they should also add the column to the customer_new table. If you can't control the addition of new columns, you're going to have to write a schema compare routine that can migrate the changes from customer to customer_new. Maybe you could license some schema compare tools and include the comparison in the process.
15 People are following this question.
