January 24, 2017 at 7:07 am
Hi,
I've package that reads data from iSeries database. I'm using ODBC connection to pull multiple tables from iSeries database to our SQL Server 2012 database.
All my tables load very fast except one table which loads very slow. When this particular table starts loading, it reads at the same pace as others tables when you look at the data flow but along the process it deteriorate the speed to the point where it takes more than 2 minutes to see the records changing on the data flow.
Please advise what could the cause. My ODBC source has been set to FetchMethod Row by Row
My OLE DB destination has been set as follows:
Data access mode: Table or view - fast load
Rows per batch : 10000
Maximum insert commit size:100000
Table lock and Check constraints not ticked.
I also tried using Balance Data Distributor but it does not help. Your help in this regard will be highly appreciate.
January 24, 2017 at 1:13 pm
pmaceke - Tuesday, January 24, 2017 7:07 AMHi,I've package that reads data from iSeries database. I'm using ODBC connection to pull multiple tables from iSeries database to our SQL Server 2012 database.
All my tables load very fast except one table which loads very slow. When this particular table starts loading, it reads at the same pace as others tables when you look at the data flow but along the process it deteriorate the speed to the point where it takes more than 2 minutes to see the records changing on the data flow.Please advise what could the cause. My ODBC source has been set to FetchMethod Row by Row
My OLE DB destination has been set as follows:
Data access mode: Table or view - fast load
Rows per batch : 10000
Maximum insert commit size:100000
Table lock and Check constraints not ticked.I also tried using Balance Data Distributor but it does not help. Your help in this regard will be highly appreciate.
Can I suggest, for testing purposes, replacing your OLEDB destination with a Trash Destination and rerunning? This will help you narrow down whether it is the source query or the target insert which is causing the problem.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
January 27, 2017 at 11:12 pm
Phil Parkin - Tuesday, January 24, 2017 1:13 PMpmaceke - Tuesday, January 24, 2017 7:07 AMHi,I've package that reads data from iSeries database. I'm using ODBC connection to pull multiple tables from iSeries database to our SQL Server 2012 database.
All my tables load very fast except one table which loads very slow. When this particular table starts loading, it reads at the same pace as others tables when you look at the data flow but along the process it deteriorate the speed to the point where it takes more than 2 minutes to see the records changing on the data flow.Please advise what could the cause. My ODBC source has been set to FetchMethod Row by Row
My OLE DB destination has been set as follows:
Data access mode: Table or view - fast load
Rows per batch : 10000
Maximum insert commit size:100000
Table lock and Check constraints not ticked.I also tried using Balance Data Distributor but it does not help. Your help in this regard will be highly appreciate.
Can I suggest, for testing purposes, replacing your OLEDB destination with a Trash Destination and rerunning? This will help you narrow down whether it is the source query or the target insert which is causing the problem.
Thank you for the feedback, we currently don't have trash destination
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply