Re: SSIS Pulling Data from an AS400

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
Date: Mon, 15 May 2006 10:20:58 +0000 (UTC)

Hello KGO,

Is there anything on the driver itself that you can set when creating the connection manager.

You may be able to tweak the "DefaultBufferSize" and "DefaulBufferMaxRows" on the Data Flow task to see if this helps.

Thanks

Allan

Hi,
My team is converting from DTS to SSIS and we are having a few
performance
problems. We pull data from an AS400 into sql server. Originally
with DTS,
this process was slow, but we significantly increased perfomance by
setting a
large fetchbuffersize on the DataPumpTask. Is there a way to set the
FetchBufferSize in SSIS? We are using the New "OLE DB for DB2" driver
to
connect to the AS400.
Thanks for your help.

Prev by Date: Re: Error when running SQL 2000 dts Package in SQL Server 2005
Next by Date: Re: Import data from Access to SQL2005 on daily basis
Previous by thread: Re: Error when running SQL 2000 dts Package in SQL Server 2005
Next by thread: Re: Scheduled Package Results Contradictory
Index(es):
- Date
- Thread

Relevant Pages

Re: The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
... I just tried installing the new driver, and found it doesn't help me import from Access, so I guess something is still missing like the asam driver issue in the article. ... I got my import to work, but using what I consider a kludge approach. ... I then saved my SSIS package to SQL and changed the job step from SSIS to Operating System type. ...
(microsoft.public.sqlserver.setup)
Re: SSIS is pathetic with ODBC connections ...
... fetch data from a Double Byte Progress database and the "DataReader ... that SSIS is a totally rewritten version of DTS. ... Can you use an OLE DB driver? ...
(comp.databases.ms-sqlserver)