Comments
Sort by recent activity
MckMurray said:
Thanks Eddie,
I see now that is mostly working - although there is one case that isn't:
One of the tables I want to import has an optional FK to another table that I do not want to import. In the source data there is only one row that has a value in this FK column. I chose the option to "skip the row" if invalid data is encountered, but it doesn't seem to be doing that. Instead, it fails the whole table insert (inserts 0 rows), and all subsequent tables can't be updated because it says "IDENTITY_INSERT is already on for table <failed table>. Cannot perform SET operation for table <subsequent table>".
Any suggestions?
Thanks
Is there a resolution to this? Do you have to turn off identity columns for all the tables getting populated in order for this to properly work? / comments
MckMurray said:
Thanks Eddie,
I see now that is mostly working - although there is one case that isn't:
One of the tables I want to import has an optional FK to another table that I do not wa...
I figured this out. the "Copy Identity column values" was checked.I thought this meant to copy over the identity values from the source database and therefore set it to true. / comments
I figured this out. the "Copy Identity column values" was checked.I thought this meant to copy over the identity values from the source database and therefore set it to true.