I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I'm not sure how to cope with PK's that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner table eg. A list of addresses 3) Reference table eg. For address types I have loaded tab1 but ignored FK to tab2, as I do not know what the FK is because this has not been generated yet. How do I now load tab2 AND update tab1 FK field with the now generated PK from tab2? I hope I have explained that OK. Thanks
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!