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