Update Recordset with foreach loop

• jfloan

  SSC Veteran

  Points: 293

  More actions

  January 11, 2013 at 10:32 pm

  #266972

  Hello all, I am very inexperienced with BI and SSIS.

  Here's what I am doing, I have an OLE DB as my source, and a Recordset as my destination.

  What I need to do, is loop through the 9 million rows in my recordset, and update some values in the row I am on. I am able to loop through the data with the foeach loop container. I just don't know how to update my recordset.

  Any help is appreciated!

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  January 12, 2013 at 10:18 pm

  #1576659

  Please do not cross-post. It just fragments replies and wastes people's time.

  Direct all replies here: http://www.sqlservercentral.com/Forums/Topic1406350-148-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato