<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogical.se/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>BizTalk SQL Message Archive component using Forward-Only Streaming</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx</link><description>A colleague of mine, Christoph Hanser , came to me with the idea you could use the UPDATETEXT command to stream data to a SQL database. This approach would work well with a forward-only streaming manner, which would consume much less (BizTalk) resources</description><dc:language>en</dc:language><generator>CommunityServer 2007.1 (Build: 20917.1142)</generator><item><title>re: BizTalk SQL Message Archive component using Forward-Only Streaming</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx#7846</link><pubDate>Wed, 03 Jun 2009 20:37:02 GMT</pubDate><guid isPermaLink="false">19a535f3-07d9-4378-9c5a-8d019d91e842:7846</guid><dc:creator>wmmihaa</dc:creator><description>&lt;p&gt;The thought never crossed my mind, and I'm not sure it's a good idea. We've used Reporting Services in favor of the BAM Portal. This, of course, gives us more freedom.&lt;/p&gt;
&lt;p&gt;//Mikael&lt;/p&gt;
&lt;img src="http://blogical.se/aggbug.aspx?PostID=7846" width="1" height="1"&gt;</description></item><item><title>re: BizTalk SQL Message Archive component using Forward-Only Streaming</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx#7810</link><pubDate>Tue, 02 Jun 2009 18:51:56 GMT</pubDate><guid isPermaLink="false">19a535f3-07d9-4378-9c5a-8d019d91e842:7810</guid><dc:creator>Bruno</dc:creator><description>&lt;p&gt;Excellent Post.&lt;/p&gt;
&lt;p&gt;But I have a doubt.....How can I insert the message body in BAM database to see in BAM Portal?&lt;/p&gt;
&lt;p&gt;[]s,&lt;/p&gt;
&lt;img src="http://blogical.se/aggbug.aspx?PostID=7810" width="1" height="1"&gt;</description></item><item><title>re: BizTalk SQL Message Archive component using Forward-Only Streaming</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx#4554</link><pubDate>Thu, 05 Mar 2009 05:53:49 GMT</pubDate><guid isPermaLink="false">19a535f3-07d9-4378-9c5a-8d019d91e842:4554</guid><dc:creator>Imminewek</dc:creator><description>&lt;p&gt;Excellent site blogical.se and I am really pleased to see you have what I am actually looking for here and this this post is exactly what I am interested in. It&amp;#39;s taken me literally 1 hours and 45 minutes of searching the web to find you (just kidding!) so I shall be pleased to become a regular visitor :)&lt;/p&gt;&lt;img src="http://blogical.se/aggbug.aspx?PostID=4554" width="1" height="1"&gt;</description></item><item><title>re: BizTalk SQL Message Archive component using Forward-Only Streaming</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx#3808</link><pubDate>Fri, 30 Jan 2009 17:25:54 GMT</pubDate><guid isPermaLink="false">19a535f3-07d9-4378-9c5a-8d019d91e842:3808</guid><dc:creator>Scott</dc:creator><description>&lt;p&gt;Excellent Post.&lt;/p&gt;
&lt;p&gt;I have been looking for a good way to handle this.&lt;/p&gt;
&lt;p&gt;Im porting it over to my project and am getting an object reference not set on my connectionstring property in the designer.&lt;/p&gt;
&lt;p&gt;Any ideas?&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;
&lt;p&gt;Scott&lt;/p&gt;
&lt;img src="http://blogical.se/aggbug.aspx?PostID=3808" width="1" height="1"&gt;</description></item><item><title>re: BizTalk SQL Message Archive component using Forward-Only Streaming</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx#3166</link><pubDate>Wed, 24 Dec 2008 01:17:18 GMT</pubDate><guid isPermaLink="false">19a535f3-07d9-4378-9c5a-8d019d91e842:3166</guid><dc:creator>Gordon</dc:creator><description>&lt;p&gt;Hi. Good news.&lt;/p&gt;
&lt;img src="http://blogical.se/aggbug.aspx?PostID=3166" width="1" height="1"&gt;</description></item><item><title>re: BizTalk SQL Message Archive component using Forward-Only Streaming</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx#1641</link><pubDate>Thu, 09 Oct 2008 05:31:59 GMT</pubDate><guid isPermaLink="false">19a535f3-07d9-4378-9c5a-8d019d91e842:1641</guid><dc:creator>alidgicasar</dc:creator><description>&lt;p&gt;nice work, guy&lt;/p&gt;
&lt;img src="http://blogical.se/aggbug.aspx?PostID=1641" width="1" height="1"&gt;</description></item><item><title>re: BizTalk SQL Message Archive component using Forward-Only Streaming</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx#1612</link><pubDate>Tue, 07 Oct 2008 03:49:42 GMT</pubDate><guid isPermaLink="false">19a535f3-07d9-4378-9c5a-8d019d91e842:1612</guid><dc:creator>alidgicasar</dc:creator><description>&lt;p&gt;thats for sure, bro&lt;/p&gt;
&lt;img src="http://blogical.se/aggbug.aspx?PostID=1612" width="1" height="1"&gt;</description></item><item><title>What I Learned Yesterday 12 &amp;laquo; Ben Runchey&amp;#8217;s Integration Dev Blog</title><link>http://blogical.se/blogs/mikael/archive/2008/04/30/biztalk-sql-message-archive-component-using-forward-only-streaming.aspx#518</link><pubDate>Tue, 27 May 2008 20:14:32 GMT</pubDate><guid isPermaLink="false">19a535f3-07d9-4378-9c5a-8d019d91e842:518</guid><dc:creator>What I Learned Yesterday 12 « Ben Runchey’s Integration Dev Blog</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;What I Learned Yesterday 12 &amp;amp;laquo; Ben Runchey&amp;amp;#8217;s Integration Dev Blog&lt;/p&gt;
&lt;img src="http://blogical.se/aggbug.aspx?PostID=518" width="1" height="1"&gt;</description></item></channel></rss>