question

Troy_2012 avatar image
Troy_2012 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
ssissql-server-2012tables
tables.jpg (73.7 KiB)
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Troy_2012 avatar image Troy_2012 commented ·
PLZ any Expert with SSIS?
0 Likes 0 ·
KenJ avatar image KenJ commented ·
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.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.