question

johnsmith avatar image
johnsmith asked

Archive lookup table

Hi, I have a database with 100 tables. I have a main customer table (Primary Key CutomerID) and need to archive all customer records where status = Dormant . The customer table is related to 80 other tables where CustomerID is Foreign Key . The requirement is to archive the customer table together with all lookup tables where Status= dormant in the customer table into an Archive Database. Is there any way to automatically relate all the tables in SSIS. I tried to use Lookup , but I am not able to link all the tables at once. Is there any other way to do this Thanks John
ssislookups
1 comment
10 |1200

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

JohnM avatar image JohnM commented ·
Can you please clarify "automatically relate" all of the tables? Meaning you want to see all of the FK relationships?
0 Likes 0 ·

1 Answer

·
johnsmith avatar image
johnsmith answered
Hi For each one record where status = dormant in Customer Table, I have 80 lookup tables to be archived. I'm currently using lookup transformation in SSIS. However , i can only transfer one table at a time ( from Live DB to Archive DB) By automatically, i mean any way to connect to the 80 lookup tables at once and transfer the records to the Archive DB. Thanks J
10 |1200

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

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.