none
Can VS 2010 and TDS support SQL 2008 BIDS stuff

    Question

  • Hello all:

    Our current environment is SQL 2008 (NOT sp 2), Visual Studio 2008, and Visual Source Safe )version 6, I think). We are currently going through an upgrade to Visual Studio 2010 for development, and Team Foundation Server for the version control, but SQL is staying at 2008.

    The question is this: can I use VS 2010 and TFS to edit, secure, and deploy my SQL 2008 BI objects (SSIS, SSRS, SSAS) ?

    I have heard chatter about VS 2010 not being compatibile with SSIS 2008 packages. Would I need to stick with my VS 2008 installation for now? And if so, can VS 2008 interface well with FTS 2010 for version control?


    Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
    Saturday, July 24, 2010 7:45 PM

Answers

All replies

  • The chatter is accurate.  You'll need to run BIDS 2008 or VS 2008 next to VS 2010.  

    2008 will work with TFS 2010 but you'll need to work with it to get it going.  This covers the steps

    http://blog.jmedved.com/2009/11/visual-studio-2008-and-team-foundation.html


    Ted Krueger Blog on lessthandot.com @onpnt on twitter
    • Marked as answer by Todd C Tuesday, July 27, 2010 2:40 PM
    Saturday, July 24, 2010 11:24 PM
    Moderator
  • NOTE that don't bring your ssis project into VS2010, because:
    Beware that there is a known issue if you try to open the projects. VS will upgrade your project, but the project won't open after that. http://support.microsoft.com/kb/983332
    The workaround is discussed in the KB to rebuild the project in the lower version.

    In general, the only way to develop business intelligence project (Reporting Services, Integration Services, Analysis Serivces is to use the older Visual Studio version. If you need both the new and the old version, VS supports a side by side install to keep your VS 2005 or VS 2008 running on the same machine as VS 2010.




    and unfortunately, ability to open SSIS projects in VS2010 not yet implemented, look at microsoft post here:
    First of all, thank you to those customers who have offered feedback regarding how your work and productivity are impacted by Integration Services (SSIS) not yet being available in Visual Studio 2010. As developers ourselves, we certainly understand the frustration you have reported in having two Visual Studio instances installed and maintained on your development machines. While this side-by-side configuration works, it is certainly a less ideal solution to operating SSIS from within VS 2010. Unfortunately, the staggered ship cycles of the two products (VS and SSIS) and some convoluted dependencies did not allow us to reunite the development environments of both tools until the next version of SQL Server.

    Meanwhile, please be assured that SSIS projects continue to be supported by Visual Studio both now and into the foreseeable future. Until the next version of SQL Server, we will be happy to discuss with any Visual Studio 2010 customer ways in which they can optimize the interoperability of VS and SSIS. We apologize for any inconvenience and are committed to improving your user experience both now and in the future.




    reference:
    https://connect.microsoft.com/SQLServer/feedback/details/508552/ssis-vs2010-project-type?wa=wsignin1.0


    this may also help to connect from VS2008 to TFS 2010:
    http://social.msdn.microsoft.com/Forums/en/tfsgeneral/thread/abbe48d2-1853-480d-b9c7-1d3d78251e40



    http://www.rad.pasfu.com
    Sunday, July 25, 2010 3:52 AM
    Moderator