July 8, 2010 at 11:03 am
Hi,
I have installed sql server 2008 yesterday which we have the new server on it(mandes02/dev) and SSMS,and i have created a package which will pull data from different server in sql 2005 into the new sql 2008 mandes02/dev .
The package is very simple and will have only OLEDB source and destination.but the ssis is taking 1 minute to pull only 17,000 rows and 40 min to pull 1,196,355 rows ...
How to reduce the performance here?
my superior told me since sql 2008 is on mandes02/dev it will not take much time to pull data..
July 8, 2010 at 11:03 pm
Check the properties of the ole-db destination - by default it inserts row by row committing as it goes (i.e. a commit per record). Change the Data access mode to "Table or view - fast load" and set a reasonable values for "rows per batch" and "maximum insert commit size" (perhaps 5000 or 10000).
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply