Geeks With Blogs
Jeffrey's Blog .Net Developer

Just a post to help those newbies to BAM, like me, out there in regards to an issue I encountered getting my OLAP cubes to display data.

The BizTalk 2006 R2 documentation describing getting BAM to work is based on using a SQL Server 2000 database, and in particular DTS.  In an environment using SQL Server 2005, DTS is not used, but Integration Services.  So if you encounter a situation where you are successfully adding to BAM (re., the primary import database), but your aggregation views are not displaying data:

  • Make sure Integration Services is running
  • Run the relevant BAM packages in the Integration Services (e.g., connect to Integration Services using SQL Server Management Studio and find the packages under the stored packages section)
Posted on Friday, September 21, 2007 11:32 AM BAM , Error | Back to top

Comments on this post: BAM 2006 with SQL Server 2005

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Chilberto | Powered by: