BAM and SSIS?

Viewing 1 reply thread
  • Author
    Posts
    • #18613

      Again in Jefford’s “Professional BT2006 Server” book, he refers to the BM utility creating SSIS package or DTS packages when running SQL 2000.

      My understanding was that you had to use SQL 2000 Analysis services.  Is that not true?  Then when I set up the BT Config utility, it required that the BAM Primary Import table also be installed on SQL 2000 (i.e. not a different server than where the cubes were?).  Am I correct.  If so, in what case would SSIS packages ever be created?

      Thanks,
      Neal Walters
      http://Biztalk-Training.com

       

    • #18645

      No you don’t have to use SQL Server 2000 Analysis Services with SQL Server 2005 although you can elect to do this if you require.  As per:

      http://msdn2.microsoft.com/en-us/library/aa577356.aspx

      Hope that helps

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.