none
Business Intelligence Objects with SQL Server 2008 R2 Client

    Question

  • Hi,

    Is there a way of installing Business Intelligence Objects on Visual Studio 2008 together with SQL Server 2008 R2 Client?

    I'm trying to access a vb.net project which imports a dts runtime DLL, which was created using SQL server 2008 R2.

    I just have SQL Client 2008 R2, so I don't have the correct DLLs. I can't even create a new business  intellience project.

    Thanks,

    Nesan Pather

    • Moved by lucy-liu Wednesday, March 07, 2012 6:56 AM it is a ssis issue (From:Visual Studio Extensibility)
    Monday, March 05, 2012 3:31 PM

Answers

  • Both 2008R2 and 2008 contain appropriate DLLs for installing BIDS.  You don't need to "mix and match" or have SQL 2008 bits in order for VS2008 to function.

    Todd McDermid's Blog Talk to me now on

    • Proposed as answer by Eileen Zhao Friday, March 09, 2012 3:22 AM
    • Marked as answer by Eileen Zhao Tuesday, March 13, 2012 1:12 AM
    Wednesday, March 07, 2012 4:38 PM
    Moderator

All replies

  • Hi Sprucegoose101,

    This is a SSIS issue, I will move it to SSIS forum for a better support.

    Thank you for your understanding!


    Lucy Liu [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, March 07, 2012 6:55 AM
  • With Business Intelligence Objects, do you mean BIDS (Business Intelligence Development Studio)?
    You can install that using the SQL Server set-up. (under the shared components)

    MCTS, MCITP - Please mark posts as answered where appropriate.
    Answer #1: Have you tried turning it off and on again?
    Answer #2: It depends...

    Wednesday, March 07, 2012 7:37 AM
  • Hi,

    Is there a way of installing Business Intelligence Objects on Visual Studio 2008 together with SQL Server 2008 R2 Client?  Answer: YES

    I'm trying to access a vb.net project which imports a dts runtime DLL, which was created using SQL server 2008 R2.

    I just have SQL Client 2008 R2, so I don't have the correct DLLs. I can't even create a new business  intellience project.

    For the later part, as far as I understand, you need the DLL's. Right?


    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Wednesday, March 07, 2012 7:53 AM
  • Both 2008R2 and 2008 contain appropriate DLLs for installing BIDS.  You don't need to "mix and match" or have SQL 2008 bits in order for VS2008 to function.

    Todd McDermid's Blog Talk to me now on

    • Proposed as answer by Eileen Zhao Friday, March 09, 2012 3:22 AM
    • Marked as answer by Eileen Zhao Tuesday, March 13, 2012 1:12 AM
    Wednesday, March 07, 2012 4:38 PM
    Moderator