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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics