<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title>Loop through ADO recordset in SSIS</title>
		<description>Discuss Loop through ADO recordset in SSIS</description>
		<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html</link>
		<lastBuildDate>Tue, 07 Apr 2026 22:48:32 +0000</lastBuildDate>
		<generator>JComments</generator>
		<atom:link href="https://selectsql.com/jcomments/rss/com_content/7" rel="self" type="application/rss+xml" />
		<item>
			<title>Virginia says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-120</link>
			<description><![CDATA[I really appreciate this excellent example!!! Fixes a problem I had for 2 days running. Also excellent example of how to deal with ADO Enumerated variables in Visual Basic!]]></description>
			<dc:creator>Virginia</dc:creator>
			<pubDate>Mon, 29 Oct 2012 13:56:02 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-120</guid>
		</item>
		<item>
			<title>Paul says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-114</link>
			<description><![CDATA[Hi, Thanks so much for your post and your time. I found it very useful. Just one question: A read in several discussions that the foreach task is not intended to run over large datasets. Now I'm trying to update customer data over more than 1 million customers and your solution seems to be too slow. Could you recommend me an alternative to large datasets? Kind Regards, Paul]]></description>
			<dc:creator>Paul</dc:creator>
			<pubDate>Thu, 09 Aug 2012 13:22:24 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-114</guid>
		</item>
		<item>
			<title>Veera says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-112</link>
			<description><![CDATA[Thanks a lot. I was looking for the same solution. You saved my time.]]></description>
			<dc:creator>Veera</dc:creator>
			<pubDate>Thu, 02 Aug 2012 10:43:35 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-112</guid>
		</item>
		<item>
			<title>JJJ says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-88</link>
			<description><![CDATA[Wow!! I followed step by step and it worked the first execution!! Tnaks a lot! You have saved me a lot of time!]]></description>
			<dc:creator>JJJ</dc:creator>
			<pubDate>Thu, 21 Jun 2012 10:32:08 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-88</guid>
		</item>
		<item>
			<title>acinau says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-63</link>
			<description><![CDATA[Thank-you. It was a great help. :-) Incidentally, the VB script played up on BIDS2008.]]></description>
			<dc:creator>acinau</dc:creator>
			<pubDate>Wed, 28 Mar 2012 20:49:33 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-63</guid>
		</item>
		<item>
			<title>adminCR says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-59</link>
			<description><![CDATA[:D That is so damn perfect. I have learned something new today. Thanks for this blog :-)]]></description>
			<dc:creator>adminCR</dc:creator>
			<pubDate>Fri, 27 Jan 2012 21:46:49 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-59</guid>
		</item>
		<item>
			<title>Joe Schmoe says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-58</link>
			<description><![CDATA[Thanks a lot! I spent 2 hours trying to get FOREACH ADO enumerator to work until I found this example.]]></description>
			<dc:creator>Joe Schmoe</dc:creator>
			<pubDate>Thu, 05 Jan 2012 22:20:41 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-58</guid>
		</item>
		<item>
			<title>Erin says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-57</link>
			<description><![CDATA[Thanks! This helped me get exactl what I needed very quickly.]]></description>
			<dc:creator>Erin</dc:creator>
			<pubDate>Thu, 05 Jan 2012 18:02:18 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-57</guid>
		</item>
		<item>
			<title>geos says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-56</link>
			<description><![CDATA[Thanks]]></description>
			<dc:creator>geos</dc:creator>
			<pubDate>Wed, 21 Dec 2011 04:21:36 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-56</guid>
		</item>
		<item>
			<title>ndles says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-52</link>
			<description><![CDATA[Thanks for the sample, I'm just wondering if you know of a way to insert a resultset stored in a variable of type object into a sql table. I have the part where the object is holding the resultset of a stored procedure call. Any suggestions welcome Thanks]]></description>
			<dc:creator>ndles</dc:creator>
			<pubDate>Wed, 28 Sep 2011 12:22:58 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-52</guid>
		</item>
		<item>
			<title>Stanislav Duben says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-48</link>
			<description><![CDATA[ If Loop return error you can use on error arrow (red one) or you can setup condition step before with some Count, and based on results go to loop or not.]]></description>
			<dc:creator>Stanislav Duben</dc:creator>
			<pubDate>Thu, 18 Aug 2011 22:15:26 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-48</guid>
		</item>
		<item>
			<title>Stanislav Duben says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-47</link>
			<description><![CDATA[ In first step you can use SELECT Count(*) FROM ... save result as variable. But this loop is FOR EACH, that means you don't need use count as parameter. This Loop do it automatically.]]></description>
			<dc:creator>Stanislav Duben</dc:creator>
			<pubDate>Thu, 18 Aug 2011 22:13:49 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-47</guid>
		</item>
		<item>
			<title>Scotty says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-44</link>
			<description><![CDATA[Great article, but a question I have is how do you raise an event/error if no rows were returned by the select into the object? It looks like I am going to need an expression in either the precedence constraint or the foreach loop to make it fail when the collection is empty, but I can't seem to work out how to access the object returned.]]></description>
			<dc:creator>Scotty</dc:creator>
			<pubDate>Mon, 13 Jun 2011 08:36:33 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-44</guid>
		</item>
		<item>
			<title>tran says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-43</link>
			<description><![CDATA[This is very helpful. Thanks! Question: How do you determine the number of records in the result set?]]></description>
			<dc:creator>tran</dc:creator>
			<pubDate>Thu, 19 May 2011 00:55:46 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-43</guid>
		</item>
		<item>
			<title>Arthi says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-42</link>
			<description><![CDATA[Thank you sooo much!...your blog helped me a lot!]]></description>
			<dc:creator>Arthi</dc:creator>
			<pubDate>Fri, 08 Apr 2011 15:58:20 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-42</guid>
		</item>
		<item>
			<title>Barry says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-40</link>
			<description><![CDATA[Thank you. Thank You. This worked great and provided details, explanations, and most important to me, you also included step by step images.]]></description>
			<dc:creator>Barry</dc:creator>
			<pubDate>Fri, 18 Mar 2011 16:43:00 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-40</guid>
		</item>
		<item>
			<title>UNSC01 says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-36</link>
			<description><![CDATA[GOD bless you!! :D :lol:]]></description>
			<dc:creator>UNSC01</dc:creator>
			<pubDate>Fri, 07 Jan 2011 20:24:13 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-36</guid>
		</item>
		<item>
			<title>Kewal says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-35</link>
			<description><![CDATA[This will help me to built SSIS packages. Thanks alot :D]]></description>
			<dc:creator>Kewal</dc:creator>
			<pubDate>Mon, 15 Nov 2010 08:29:25 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-35</guid>
		</item>
		<item>
			<title>Vicky says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-27</link>
			<description><![CDATA[Thanks so much!!! So detailed and to the point. This was BIG help!!!!!]]></description>
			<dc:creator>Vicky</dc:creator>
			<pubDate>Thu, 24 Jun 2010 20:48:03 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-27</guid>
		</item>
		<item>
			<title>Jane says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-23</link>
			<description><![CDATA[THank you. The example you provided has been most helpful.]]></description>
			<dc:creator>Jane</dc:creator>
			<pubDate>Tue, 26 Jan 2010 09:36:40 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-23</guid>
		</item>
		<item>
			<title>Chris Page says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-22</link>
			<description><![CDATA[I've just spent an hour trying to make this work! Your code works perfectly. Interpreted to mine it fails. Was reaching that "throw the machine out the window" stage when I had an idea. When embedded in other code this seems to only work when embedded in a sequence container to ensure that the EST happens before the FeLC.]]></description>
			<dc:creator>Chris Page</dc:creator>
			<pubDate>Mon, 21 Dec 2009 16:38:30 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-22</guid>
		</item>
		<item>
			<title>harty says:</title>
			<link>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-21</link>
			<description><![CDATA[Just wanted to say Thank you for your blog. I really appreciate such resources where people write about real life, real problems, real joy... Your resource belongs to my favorites.]]></description>
			<dc:creator>harty</dc:creator>
			<pubDate>Fri, 21 Aug 2009 12:16:18 +0000</pubDate>
			<guid>https://selectsql.com/mssql/loop-through-ado-recordset-in-ssis.html#comment-21</guid>
		</item>
	</channel>
</rss>
