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

Harinadh 1

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

ShaikMaheer-MSFT 38,446 Reputation points Microsoft Employee

2021-06-14T12:25:37.267+00:00

Hello @Harinadh ,

Just checking in to see if the below answer provided by @Nandan Hegde 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.
ShaikMaheer-MSFT 38,446 Reputation points Microsoft Employee

2021-06-18T07:40:47.82+00:00

Hi @Harinadh

Just checking in to see if the below answer provided by @Nandan Hegde 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.
ShaikMaheer-MSFT 38,446 Reputation points Microsoft Employee

2021-06-21T03:02:25.003+00:00

Hi @Harinadh

Just checking in to see if the below answer provided by @Nandan Hegde 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.

1 answer

Nandan Hegde 32,026 Reputation points MVP

2021-06-12T08:55:59.073+00:00

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)
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

1 answer

Your answer