Identity columns with ado.net destination
I have a data flow task which moves data from ado.net source to ado.net destination. This table has got identity columns.
One option is to have a execute SQL task prior to the dataflow which makes a identity_insert on for that table and then have the same connection do the transfer as well.
I currently have the package but it doesn't have the execute sql task. Now the package doesn't seem to automatically populate the identity columns, It just copies it. I am not sure how it does though.
What I need to know is what are all the options that I have such that the identity values are same across source and destination.
Thanks in advance. Regards, Ashwin Menon My Blog - http:\\sqllearnings.com
April 20th, 2012 11:23am
It copies the identity as defined in the source, the population should not occur before you move the data.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
April 20th, 2012 12:13pm
It copies the identity as defined in the source, the population should not occur before you move the data.Arthur My Blog
April 20th, 2012 6:56pm