CODEWITHSUNDEEP
ssis
Koti Raavi
Koti Raavi

Reputation: 310

SSIS Performance Issue

I'm loading some text files to a SQL Server Database. Each file contains 1000 records and the total number of files is 15.

Problem is each file is taking more than 5 mins time to load.

The files contain 12 columns (String).

I am converting 2 columns into integer using a derived column and the remaining 10 are loading as string

Below is the code used for conversion:

  (DT_I4)Mailer_ID
  (DT_I4)Move_Effective_Date

I have tried to increase DFT buffer size and using data conversion in place of the derived column. But the problem still exists.

Upvotes: 0

Views: 39

Answers (1)

Kannan Kandasamy
Kannan Kandasamy

Reputation: 13959

Try loading directly from source and put into staging, While accessing the data from staging do your transformation.

Upvotes: 1

Related Questions