Post reply

Get SqlDataReader instead of RecordSet in Execute SQL task

  • February 28, 2014 at 12:09 pm

    #282961

    I can store my SQL result set into a ADODB record set or ADO.NET recordset. In .NET

    I can use a .NET connection manager, get .NET DataSet, extract the DataTable from

    this DataSet and use it. The problem is that I am getting about 30-40K rows in memory.

    I don't want to do that. I want to get a SqlDataReader into "some kind of .NET recordset"

    so that I can read row by row instead of all at once. How do I do this ? I want to use C# and .NET only.

    Thanks.

  • February 28, 2014 at 12:33 pm

    #1693240

    Are you passing the recordset into a script task for the record by record operation? if so, you can perform the procedure execute in the script task and it will behave as you would expect.

    This is not the normal approach when using SSIS as data flows are typically used to pump data between systems.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply