posted on Saturday, February 12, 2005 11:37 AM by Knight_Reign

Shredding recordsets in the ForEachADO Enumerator

Ash blogged about this recently. I've been meaning to blog on it as well. We've known it was an issue, but didn't know how much of one until we started hearing things like "You're not seriously considering shipping like this are you?" and "This is really much too much work just to enumerate recordsets" and the ever abiding "This sucks". :)

So, we've taken a look and it appears that there was a way to enable the ADO enumerator to shred the recordsets for you.
This should be available soon. :)

Thanks Matt!!!

Update: you can see here that we've finished this now and there is no longer a need to hack around a solution!


Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden

Comments

# SSIS: Accessing a recordset in a script task @ Sunday, February 13, 2005 9:21 AM

Knight_Reign

# Table driven foreach loops @ Friday, March 25, 2005 2:37 PM

Table driven foreach loops

Knight_Reign

# SSIS: Accessing a recordset in a script task @ Tuesday, January 16, 2007 1:19 PM

UPDATE 2006-03-14: This information in this post should now be disregarded. Read here: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx

Anonymous

# Table driven foreach loops(zz) @ Wednesday, January 23, 2008 10:56 AM

http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/25/9588.aspx InanearlierblogImention...

Anonymous