0

I am trying to do a simple copy data from csv in ADLS to Azure Synapse in ADF Pipeline . I have also set pre Copy script to Identity Insert ON but still the Copy activity fails with "An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON".

I know that if identity insert is ON the Synapse will expect the column names to be listed but how do we do it in copy activity of ADF ? Or how to copy data from csv to synapse with identity column in Azure synapse ?

PAVAN
  • 33
  • 1
  • 4
  • Are you trying to insert data into an identity column via copy activity? If no, then skip the column in mapping – Nandan Oct 26 '22 at 13:02
  • Yes I am trying to insert the identity column also. I tried Bulk Insert in the copy activity. Which worked fine. Is that the right approach ? – PAVAN Oct 27 '22 at 06:16

1 Answers1

0

When you are copying data into an identity column, ADF auto takes care w.r.t identity insert on and Off, there is no explicit need to execute anything. So bulk insert would work. enter image description here

Nandan
  • 3,939
  • 2
  • 8
  • 21
  • Great it could help! Can you please upvote and mark it as answer as it benefit other community members as well – Nandan Oct 28 '22 at 05:44