Update Recordset with foreach loop

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Update Recordset with foreach loop

Update Recordset with foreach loop

Rate Topic

Display Mode

Topic Options

Author

Message

jfloan

Posted Friday, January 11, 2013 10:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, January 12, 2013 10:19 PM
Points: 8, Visits: 31

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!

Post #1406307

opc.three

Posted Saturday, January 12, 2013 10:18 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 6,730, Visits: 11,783

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1406446

« Prev Topic | Next Topic »

Permissions