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
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
21 People are following this question.
