Today the Help file for the Microsoft Connector 1.0 for SAP BI was published to the MSDN Library at this address: http://msdn.microsoft.com/en-us/library/dd326764.aspx. Previously, customers who were interested in the Connector had to download the components and install them to get access to the Help documentation.
This Help content (which does not contain screen shots) complements the valuable how-to article (which DOES contain screen shots) by Chunhui Zhu, Using SQL Server 2008 Integration Services with SAP BI 7.0.
The Connector itself can be found on this download page: Microsoft SQL Server 2008 Feature Pack, October 2008.
Check out all the free custom widgets available for SSIS
SQL Server blogger Todd McDermid, along with MVP John Welch, have set up a community project on Codeplex to serve as an informal database of free Codeplex community components for Integration Services. They've neatly categorized the list into:
- Connection Managers (1)
- Tasks (3)
- Sources (6)
- Transformations (8)
- Destinations (5)
He also lists other sources of useful free components (other than Codeplex), especially SQLIS.com.
Read Todd's most recent blog entry about this site here.
If you're interested in the architecture of BI solutions, take a look at John Welch's new blog, BIpartisan.
Problems with Search in the MSDN Forums
If you're like me, you rely heavily on the Integration Services forum on MSDN to find answers to your SSIS questions and problems. If you're getting zero hits these days on terms that you know have to be there, you're not crazy...they've acknowledged a problem and are working on it. Ironically, Live Search will find the forum postings that you're searching for.
How is a fast food joint like SQL Server?
Well, I admit that I wouldn't have known the answer either. But SQL Server MVP Simon Sabin explains the analogy for us in this clever blog post: http://sqlblogcasts.com/blogs/simons/archive/2009/01/23/Why-is-my-chip-shop-like-SQL-Server.aspx.