Azure Data Factory copy data from XML to SQL Synapse pool

Question

I've created a SQL Dedicated pool table in Synapse, and now trying to copy data from multiple XML files to this database

I've mapped all fields from the XML file that I need to each specific column in the destination table, but the following error is blocking the copy data activity:

Message=Column count in target table does not match column count specified in input. If BCP command, ensure format file column count matches destination table. If SSIS data import, check column mappings are consistent with target.,Source=.Net SqlClient Data Provider,SqlErrorNumber=107098,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=107098,State=1,Message=Column count in target table does not match column count specified in input. If BCP command, ensure format file column count matches destination table. If SSIS data import, check column mappings are consistent with target.,},],'

Any idea what I am doing wrong?

Steve Johnson · Accepted Answer · 2021-05-17 09:33:35Z

1

This is because the count of column in the XML files and Synapse is not equal. You need to check the count of your XML files and make them be same as the count of your sink's column.

answered May 17, 2021 at 9:33

Steve Johnson

8,8081 gold badge11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jacques Over a year ago

If you're only interested in two out of three columns, what then?

Collectives™ on Stack Overflow

Azure Data Factory copy data from XML to SQL Synapse pool

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related