Jorg Klein&#39;s Microsoft Business Intelligence Blog [Macaw]http://sqlblogcasts.com/blogs/jorg/default.aspxenCommunityServer 2007.1 (Build: 20917.1142)Blog moved!http://sqlblogcasts.com/blogs/jorg/archive/2009/12/13/blog-moved.aspxSun, 13 Dec 2009 21:02:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12728jorg11http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=12728http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=12728http://sqlblogcasts.com/blogs/jorg/archive/2009/12/13/blog-moved.aspx#comments<div>For a number of reasons, I have moved my blog to <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></div> <div>Please change your bookmarks ;-)</div> <div>&nbsp;</div> <div>RSS: <a href="http://sqlblog.com/blogs/jorg_klein/rss.aspx">http://sqlblog.com/blogs/jorg_klein/rss.aspx</a></div> <div>&nbsp;</div> <div>&nbsp;</div> <div>Many thanks to Tony Rogerson and Simon Sabin for making this blog possible here at sqlblogcasts for the last two years!</div> <div>&nbsp;</div><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12728" width="1" height="1">SSASSSRSSSISMS BI ExamsSSIS - Let the Excel connection manager pick the right column data types from an Excel sourcehttp://sqlblogcasts.com/blogs/jorg/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspxWed, 18 Nov 2009 20:45:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12555jorg11http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=12555http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=12555http://sqlblogcasts.com/blogs/jorg/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx</a></p> <p>&nbsp;</p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12555" width="1" height="1">SSISSSIS - Connect to Oracle on a 64-bit machinehttp://sqlblogcasts.com/blogs/jorg/archive/2009/10/15/connect-to-oracle-using-ssis-on-a-64-bits-os.aspxThu, 15 Oct 2009 12:49:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12425jorg6http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=12425http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=12425http://sqlblogcasts.com/blogs/jorg/archive/2009/10/15/connect-to-oracle-using-ssis-on-a-64-bits-os.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx</a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx"></a></p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12425" width="1" height="1">SSISSSIS – Unpack a ZIP file with the Script Taskhttp://sqlblogcasts.com/blogs/jorg/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspxThu, 27 Aug 2009 12:59:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12197jorg3http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=12197http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=12197http://sqlblogcasts.com/blogs/jorg/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx</a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx"></a></p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12197" width="1" height="1">SSISSSAS - Clear SSAS cache with an SSIS packagehttp://sqlblogcasts.com/blogs/jorg/archive/2009/02/13/ssas-clear-ssas-cache-with-an-ssis-package.aspxFri, 13 Feb 2009 15:35:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11346jorg0http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=11346http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=11346http://sqlblogcasts.com/blogs/jorg/archive/2009/02/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/03/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2009/03/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx</a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx"></a></p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11346" width="1" height="1">SSASSSAS - Speed up dimensions using a NULL default cube measurehttp://sqlblogcasts.com/blogs/jorg/archive/2009/02/06/speed-up-ssas-dimensions-using-a-null-default-cube-measure.aspxFri, 06 Feb 2009 12:07:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11323jorg3http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=11323http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=11323http://sqlblogcasts.com/blogs/jorg/archive/2009/02/06/speed-up-ssas-dimensions-using-a-null-default-cube-measure.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx</a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/03/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx"></a></p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11323" width="1" height="1">SSASStart / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch filehttp://sqlblogcasts.com/blogs/jorg/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspxTue, 06 Jan 2009 19:02:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11160jorg5http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=11160http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=11160http://sqlblogcasts.com/blogs/jorg/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx</a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/03/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx"></a></p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11160" width="1" height="1">SSASSSRSSSISSSIS - Decrease your fact table loading time up to 40%http://sqlblogcasts.com/blogs/jorg/archive/2008/10/22/ssis-decrease-your-fact-table-loading-time-up-to-40.aspxWed, 22 Oct 2008 14:57:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:10927jorg7http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=10927http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=10927http://sqlblogcasts.com/blogs/jorg/archive/2008/10/22/ssis-decrease-your-fact-table-loading-time-up-to-40.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2008/10/22/ssis-decrease-your-fact-table-loading-time-up-to-40.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2008/10/22/ssis-decrease-your-fact-table-loading-time-up-to-40.aspx</a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/03/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx"></a></p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=10927" width="1" height="1">SSISMCTS - I passed the 70-556 “Microsoft Office PerformancePoint Server 2007” exam!http://sqlblogcasts.com/blogs/jorg/archive/2008/09/23/mcts-i-passed-the-70-556-microsoft-office-performancepoint-server-2007-exam.aspxTue, 23 Sep 2008 11:56:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:10832jorg0http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=10832http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=10832http://sqlblogcasts.com/blogs/jorg/archive/2008/09/23/mcts-i-passed-the-70-556-microsoft-office-performancepoint-server-2007-exam.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2008/09/23/mcts-i-passed-the-70-556-microsoft-office-performancepoint-server-2007-exam.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2008/09/23/mcts-i-passed-the-70-556-microsoft-office-performancepoint-server-2007-exam.aspx</a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2008/10/22/ssis-decrease-your-fact-table-loading-time-up-to-40.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/03/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx"></a></p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=10832" width="1" height="1">MS BI ExamsSSIS - Convert various String date formats to DateTime with the Script Taskhttp://sqlblogcasts.com/blogs/jorg/archive/2008/06/12/ssis-convert-different-string-date-formats-to-datetime-with-the-script-task.aspxThu, 12 Jun 2008 12:01:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:10475jorg3http://sqlblogcasts.com/blogs/jorg/rsscomments.aspx?PostID=10475http://sqlblogcasts.com/blogs/jorg/commentapi.aspx?PostID=10475http://sqlblogcasts.com/blogs/jorg/archive/2008/06/12/ssis-convert-different-string-date-formats-to-datetime-with-the-script-task.aspx#comments<p>This blog has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/">http://sqlblog.com/blogs/jorg_klein/</a></p> <p>This blog post has been moved to: <a href="http://sqlblog.com/blogs/jorg_klein/archive/2008/06/12/ssis-convert-various-string-date-formats-to-datetime-with-the-script-task.aspx">http://sqlblog.com/blogs/jorg_klein/archive/2008/06/12/ssis-convert-various-string-date-formats-to-datetime-with-the-script-task.aspx</a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2008/09/23/mcts-i-passed-the-70-556-microsoft-office-performancepoint-server-2007-exam.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2008/10/22/ssis-decrease-your-fact-table-loading-time-up-to-40.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/03/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx"></a><a href="http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx"></a></p><img src="http://sqlblogcasts.com/aggbug.aspx?PostID=10475" width="1" height="1">SSIS