Recordset manipulation in SSIS

Posted by JSacksteder on Stack Overflow See other posts from Stack Overflow or by JSacksteder
Published on 2010-03-22T14:05:22Z Indexed on 2010/03/23 6:43 UTC
Read the original article Hit count: 361

Filed under:
|
|

In my SSIS job, I have a need to accumulate a set of rows and commit them all transitionally when processing has completed successfully. If this was pure SQL, I would use a temp table inside a transaction. In SSIS there are a number of issues complicating this. It's difficult to have multiple components share the same transaction and having temp tables that do not exist at design time is a pain.

If I use Recordsets inside SSIS for this purpose, there are other issues. My understanding is that an 'Execute SQL' component will re-initialize the Recordset when it runs, so I can't use that to append an additional row. Is there a way to create an OLE DB connection that references an in-memory Recordset?

Is there a better way to achieve this result?

© Stack Overflow or respective owner

Related posts about ssis

Related posts about recordset