Geek asks and answers

SSIS and ADO.NET and Azure

I am trying to move a table in SQL Azure using SSIS. I have the source and destination of ADO.NET, but when I run it, it always fails when there is an error related to disabling IDENTITY INSERT. From the other posts mentioned, I have to remove the check from the "Use bulk insert whenever possible" window. I have and still get the same error. Any ideas on how to move IDENTITY columns in SQL Azure?

thank

+3
source share
1 answer

By message, the destination has an identification field, so you have two parameters:

  • change the ADO destination to the OLEDB destination and check the "keep identity" checkbox on the target component
  • identity_insert ON , .
+2

More articles:


All Articles