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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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