Skip to Content

Records processing using Excel as source is taking time

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 02, 2017 at 08:10 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Oct 03, 2017 at 02:57 PM

    Hello Rajan Buard,

    Try Degree of parallelism option in Data Flow properties.

    Add comment
    10|10000 characters needed characters exceeded