• Strick,

    The adapter you are using is just an adapter. It takes ADO recordset and populates .NET data set. This is making your memory consumption at least twice as much because you now have a copy of the data in both ADO recordset and the dataset.

    From the approach you are using there are actually two solutions I could think of:

    1. Store the data table you get from OleDbDataAdapter in package variable and use this managed data set in the 3rd data flow. I would recommend you dispose/release the recordset object after you load the data in the adapter. It is not needed.

    2. Avoid using managed data set entirely. Use the ADO recordset directly. To do this you have to include reference to adodb library in your project. Then you have to include the following import:

    Imports ADODB

    and use the following code:

    Dim rs As Recordset = CType(Me.Variables.rsPayeeSummary, Recordset)

    and now you will have the familiar ADO Recordset in the rs variable and you can use your previous skills to pull the data from it 😉

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/