Records processing using Excel as source is taking time

[rajan_burad]

Hello Experts,

I'm trying to load the data from excel file to tables but the job is taking around 30-40 mins. Source has special characters in it. Can anyone please help me how to reduce the time taken and improve the performance of job.

Thanks.

[former_member451932]

Hello Rajan Buard,

Try Degree of parallelism option in Data Flow properties.

[rajan_burad]

I changed the DOP to 4 but no effect. Job is still taking the same approximate time. 😞

[former_member208402]

HI Rajan Burad,

What is the amount of data in source excel file ? Is it direct execl to table load or do you have any joins/transformations?

[rajan_burad]

Total records in source excel is around 700000. No joins are present, its a one to one map and one column has a datatype of varchar(4000). However I'll be converting that to long.