question

Harinadh-6408 avatar image
0 Votes"
Harinadh-6408 asked ShaikMaheer-MSFT commented

How to design a pipeline when copy the data from source to sql when source have more columns and sql table have less columns

Im trying to copy the data from file to table using copy activity. Thing is source file have 10 columns and sql table have 5 columns. When tried to run the job with automaooing getting error number of columns are not same.

Can some one help me.

Thnaks in advance

azure-data-factory
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Harinadh-6408 ,

Just checking in to see if the below answer provided by @NandanHegde-7720 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @Harinadh-6408

Just checking in to see if the below answer provided by @NandanHegde-7720 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @Harinadh-6408

Just checking in to see if the below answer provided by @NandanHegde-7720 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered NandanHegde-7720 edited

Hey,
Under mapping section in copy activity you can map only the required columns from source to sink and ignore the additional columns. (Delete it)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.