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.
--
-KGO

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