I'm in the process of moving data from one database to another. Both are Microsoft sql 2005 databases. I planning on using SSIS to do this but have run into a problem. Since the source database uses int for its primary key and the destination database uses guid for its primary key how can I preserve relationships between tables.
I am fairly new to SSIS but feel comfortable with straight forward data transfer between tables. Any advice/help would be greatly appreciated.
Thanks for the help in advance.