<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://dougbert.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Dougbert on SSIS - All Comments</title><link>http://dougbert.com/blogs/dougbert/default.aspx</link><description>SQL Server Integration Services news and tips from Microsoft technical writer Douglas Laudenschlager.</description><dc:language>en</dc:language><generator>CommunityServer 2008.5 (Build: 30929.2835)</generator><item><title>Social comments and analytics for this post</title><link>http://dougbert.com/blogs/dougbert/archive/2009/08/28/64-bit-excel-driver-in-microsoft-office-14.aspx#1521</link><pubDate>Tue, 09 Feb 2010 04:24:38 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1521</guid><dc:creator>uberVU - social comments</dc:creator><description>&lt;p&gt;This post was mentioned on Twitter by Todd_McDermid: @MladenPrajdic @mrdenny Office 2010 won&amp;#39;t have 64-bit drivers, but 14 will: &lt;a rel="nofollow" target="_new" href="http://bit.ly/4KS4qw"&gt;http://bit.ly/4KS4qw&lt;/a&gt;&lt;/p&gt;
&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1521" width="1" height="1"&gt;</description></item><item><title>Exporting issue to excel 2007 - The Code Cage Forums</title><link>http://dougbert.com/blogs/dougbert/archive/2008/08/20/excel-the-office-12-ace-provider-and-performance.aspx#1519</link><pubDate>Thu, 04 Feb 2010 11:10:03 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1519</guid><dc:creator>Exporting issue to excel 2007 - The Code Cage Forums</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Exporting issue to excel 2007 - The Code Cage Forums&lt;/p&gt;
&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1519" width="1" height="1"&gt;</description></item><item><title>re: SSIS and clustering: What you should do instead</title><link>http://dougbert.com/blogs/dougbert/archive/2009/04/09/ssis-and-clustering-what-you-should-do-instead.aspx#1446</link><pubDate>Fri, 29 Jan 2010 20:39:45 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1446</guid><dc:creator>Sneha</dc:creator><description>&lt;p&gt;Very good Post. Saved lot of my time, got better understanding of how it really works. Thanks a bunch!&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1446" width="1" height="1"&gt;</description></item><item><title>re: SSIS: Now it's play and not work!</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/07/ssis-now-it-s-play-and-not-work.aspx#1431</link><pubDate>Mon, 25 Jan 2010 17:27:36 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1431</guid><dc:creator>Phil Brammer</dc:creator><description>&lt;p&gt;Best wishes and good luck in the new role! &amp;nbsp;I&amp;#39;ll see you in Feb!&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1431" width="1" height="1"&gt;</description></item><item><title>Top 10 ??? better communication ??? ?? data warehouse | Business Intelligence Wisdom</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/18/you-could-be-doing-etl-or-bi-at-microsoft.aspx#1429</link><pubDate>Sun, 24 Jan 2010 20:51:28 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1429</guid><dc:creator>Top 10 ??? better communication ??? ?? data warehouse | Business Intelligence Wisdom</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Top 10 ??? better communication ??? ?? data warehouse | Business Intelligence Wisdom&lt;/p&gt;
&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1429" width="1" height="1"&gt;</description></item><item><title>Sun Microsystems&amp;#039; OBIEE Implementation Review | Art of Business &amp;#8230; | Management Business Wisdom</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/18/you-could-be-doing-etl-or-bi-at-microsoft.aspx#1428</link><pubDate>Sun, 24 Jan 2010 07:47:40 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1428</guid><dc:creator>Sun Microsystems' OBIEE Implementation Review | Art of Business … | Management Business Wisdom</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Sun Microsystems&amp;#039; OBIEE Implementation Review | Art of Business &amp;#8230; | Management Business Wisdom&lt;/p&gt;
&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1428" width="1" height="1"&gt;</description></item><item><title>re: SSIS: Now it's play and not work!</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/07/ssis-now-it-s-play-and-not-work.aspx#1424</link><pubDate>Sat, 23 Jan 2010 02:25:07 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1424</guid><dc:creator>PedroCGD</dc:creator><description>&lt;p&gt;I wish you the best for the next challenge!&lt;/p&gt;
&lt;p&gt;regards,&lt;/p&gt;
&lt;p&gt;Pedro&lt;/p&gt;
&lt;p&gt;www.pedrocgd.blogspot.com&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1424" width="1" height="1"&gt;</description></item><item><title>re: SSIS: Now it's play and not work!</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/07/ssis-now-it-s-play-and-not-work.aspx#1419</link><pubDate>Fri, 22 Jan 2010 13:35:40 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1419</guid><dc:creator>Jorg Klein</dc:creator><description>&lt;p&gt;I wish you the very best at your new position! Thanks for your blogposts here and the mail conversations we had!&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1419" width="1" height="1"&gt;</description></item><item><title>You could be doing ETL or BI at Microsoft! &amp;#8211; Dougbert on SSIS &amp;#8230; | Drakz Free Online Service</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/18/you-could-be-doing-etl-or-bi-at-microsoft.aspx#1411</link><pubDate>Tue, 19 Jan 2010 18:49:36 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1411</guid><dc:creator>You could be doing ETL or BI at Microsoft! – Dougbert on SSIS … | Drakz Free Online Service</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;You could be doing ETL or BI at Microsoft! &amp;#8211; Dougbert on SSIS &amp;#8230; | Drakz Free Online Service&lt;/p&gt;
&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1411" width="1" height="1"&gt;</description></item><item><title>You could be doing ETL or BI at Microsoft! &amp;#8211; Dougbert on SSIS &amp;#8230; | Drakz Free Online Service</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/18/you-could-be-doing-etl-or-bi-at-microsoft.aspx#1410</link><pubDate>Tue, 19 Jan 2010 18:49:33 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1410</guid><dc:creator>You could be doing ETL or BI at Microsoft! – Dougbert on SSIS … | Drakz Free Online Service</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;You could be doing ETL or BI at Microsoft! &amp;#8211; Dougbert on SSIS &amp;#8230; | Drakz Free Online Service&lt;/p&gt;
&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1410" width="1" height="1"&gt;</description></item><item><title>re: SSIS: Now it's play and not work!</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/07/ssis-now-it-s-play-and-not-work.aspx#1393</link><pubDate>Sat, 09 Jan 2010 02:39:40 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1393</guid><dc:creator>John Welch</dc:creator><description>&lt;p&gt;Congratulations on the new position - though we&amp;#39;ll certainly miss your input on the SSIS team.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1393" width="1" height="1"&gt;</description></item><item><title>re: Get looped, with your own custom Foreach Enumerator for SSIS</title><link>http://dougbert.com/blogs/dougbert/archive/2009/03/27/get-looped-with-your-own-custom-foreach-enumerator-for-ssis.aspx#1390</link><pubDate>Fri, 08 Jan 2010 19:44:09 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1390</guid><dc:creator>dougbert</dc:creator><description>&lt;p&gt;Robert,&lt;/p&gt;
&lt;p&gt;You can pass variable values into many of the properties of the ForEach File Enumerator, by using an SSIS expression that merely passes the variable. However to do this you have to select &amp;quot;Expressions&amp;quot; on the Collection page of the ForEach Loop Editor - that is, on the same page where you chose and configured the ForEach File Enumerator. If you look at the available properties on the Expressions page of the editor, on the other hand, you&amp;#39;ll only see the generic properties for the ForEach Loop container, not of the specific enumerator that you&amp;#39;ve chosen.&lt;/p&gt;
&lt;p&gt;-Doug&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1390" width="1" height="1"&gt;</description></item><item><title>re: SSIS: Now it's play and not work!</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/07/ssis-now-it-s-play-and-not-work.aspx#1389</link><pubDate>Fri, 08 Jan 2010 19:03:48 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1389</guid><dc:creator>Davide Mauri</dc:creator><description>&lt;p&gt;My best wishes for your new position, looks interesting and fun! Se you in february!&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1389" width="1" height="1"&gt;</description></item><item><title>re: SSIS: Now it's play and not work!</title><link>http://dougbert.com/blogs/dougbert/archive/2010/01/07/ssis-now-it-s-play-and-not-work.aspx#1388</link><pubDate>Fri, 08 Jan 2010 06:41:59 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1388</guid><dc:creator>Jamie THomson</dc:creator><description>&lt;p&gt;Argggh...noooo....say it aint so!! :)&lt;/p&gt;
&lt;p&gt;This is not great news for those of us in SSIS land but I&amp;#39;m sure its a great move for you Doug, so congratulations. Thanks for everything over the past 5 years - you&amp;#39;ve been (and I&amp;#39;m sure will continue to be) a massive contributer to the SSIS community.&lt;/p&gt;
&lt;p&gt;-Jamie&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1388" width="1" height="1"&gt;</description></item><item><title>re: Get looped, with your own custom Foreach Enumerator for SSIS</title><link>http://dougbert.com/blogs/dougbert/archive/2009/03/27/get-looped-with-your-own-custom-foreach-enumerator-for-ssis.aspx#1386</link><pubDate>Thu, 07 Jan 2010 16:33:43 GMT</pubDate><guid isPermaLink="false">f9834307-c174-40ff-a2fb-ff80b9231c9e:1386</guid><dc:creator>Robert</dc:creator><description>&lt;p&gt;Good topic! &amp;nbsp;I am facing a task right now to go through a directory and its subdirectories without knowing where the root directory starts. &amp;nbsp;First I thought that enumerating from variable is the way to go, but quickly realized that it&amp;#39;s for something else. &amp;nbsp;Do I need to write a custom enumerator? &amp;nbsp;I would like to pass the starting directory as a parameter, so that the ForEach loop container will store this value in a variable. &amp;nbsp;Pointers?&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://dougbert.com/aggbug.aspx?PostID=1386" width="1" height="1"&gt;</description></item></channel></rss>