Home Forums SQL Server 2005 SQL Server 2005 Integration Services Put data directly into DataTable or dot net object ? RE: Put data directly into DataTable or dot net object ?

  • December 16, 2013 at 10:43 am

    #1673797

    blasto_max (12/16/2013)

    LutzM (12/15/2013)

    What you've described so far is HOW you do your corrent task. But not, WHAT this task really is.

    If you'd describe the task you're faced with, we might be able to help you finding an alternative.

    Thanks. I need to iterate a result set, do some simple processing on it and then write that processed data to a file or even a database. So, I find it inefficient to first load a result set into an SSIS object and then load it into a DataTable for processing. why not load it into a DataTable in the first place ?

    Loading into another in-memory object is not going to help too much. You are still going to have enormous memory consumption if you load millions of records .

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