Skip to Content
0
Apr 14, 2014 at 03:31 PM

Data Flow Long Run

36 Views

Hi Guys,

Good day!

I am currently having a performance issue regarding with extraction of a job.
My job extracts an average of 215,000 row count for every run weekly. The extraction takes up to 3 to 4 hours long compared to the usual duration of 2 hours. As per checking of the trace log, the long run is occurring in the Data Flow.

Data flow structure:
SQL (Database Type Oracle 10g) -> Table (Microsoft SQL Server 2008)

The current configuration of the Source and Target in the designer is as follows:

SQL
Database type: Oracle 10g
Array fetch size: 1000

Table Target
Database type: Microsoft SQL Server 2008
Rows per Commit: 1000
Number of loaders: 1

With this, I would like to ask on how can I optimize the performance of the job where I can reduce the extraction time.

Thanks,