January 12, 2013 at 8:14 am
Hello, I am very new to SSIS.
I currently have 9 million rows in a recordset. I am going through each of the 9 million records in a foreach loop. What my question is, how can I change the values of a row while I am in the for each loop?
Any feedback would be greatly appreciated!
January 12, 2013 at 8:31 am
I think more information is necessary on this. Looping through 9 million records 1 at a time is rather slow and inefficient.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2013 at 8:37 am
This is simply a POC. So, back to the question, is it possible to modify the recordset?
January 12, 2013 at 8:41 am
it depends on the type of recordset. It is possible through several different means.
One of the easier methods is to add a sql script in the loop and pass parameters to it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2013 at 9:06 am
If you can make the recordset into a datasource, you can add a script component to make whatever changes you like.
January 12, 2013 at 9:08 am
Thank you Phil!!!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy