none
How to skip the mapping of Identity columns in Copy Data Sink table?

    Question

  • I'm designing a Copy Data task where the Sink SQL Server table contains an Identity column. The Copy Data task always wants me to map the Identity column when, in my opinion, it should just not include the column in the list of columns to map. Does anyone know how I can get the ADF Copy Data task to ignore Sink Identity columns?

    Randy Minder


    Tuesday, August 28, 2018 2:48 PM

All replies

  • Hi Randy, 

    Would explicit column mapping work for you?

    https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-schema-and-type-mapping#explicit-column-mapping

    Tuesday, August 28, 2018 6:04 PM
    Moderator
  • Hi Randy,

      You can try the ADF UI tool.

      1. In the schema tab of the sink dataset, you can remove that identity column easily.

      2. In the mapping tab of the copy activity, click 'import schemas' again, the identity column is gone.

    Wednesday, September 5, 2018 9:57 AM