none
problem with deploying ssis 2010 package

    Question

  • hi,

    i have installed vs 2010,sql server 2008 and sql server 2012. i have created ssis package in vs 2010. when i am trying to give connection name for sql serev while deploying package into sql server 2008 or 2012 it is giving error.

    error is:

    the version of sql server instance does not supported in the selected operation. specify a different sql server instance.(microsoft.sql server.management.integration services)

    operation not supported on version 10.50

    Please help on this

    
    • Moved by lucy-liu Tuesday, April 24, 2012 6:53 AM it is a ssis issue (From:Visual Studio Editor)
    Monday, April 23, 2012 10:04 AM

Answers

  • You can only deploy SSIS 2012 packages created in Visual Studio 2010 to SQL Server 2012.

    SQL Server 2008R2 is not an option.


    MCTS, MCITP - Please mark posts as answered where appropriate.

    • Proposed as answer by Eileen Zhao Tuesday, April 24, 2012 3:19 PM
    • Marked as answer by Eileen Zhao Wednesday, May 02, 2012 3:10 AM
    Tuesday, April 24, 2012 6:56 AM

All replies

  • Hi snmaheshbabu,

    I will move this thread to SQL Server Integration Services forum for a better support.

    Thank you for your understanding!


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

    Tuesday, April 24, 2012 6:53 AM
  • You can only deploy SSIS 2012 packages created in Visual Studio 2010 to SQL Server 2012.

    SQL Server 2008R2 is not an option.


    MCTS, MCITP - Please mark posts as answered where appropriate.

    • Proposed as answer by Eileen Zhao Tuesday, April 24, 2012 3:19 PM
    • Marked as answer by Eileen Zhao Wednesday, May 02, 2012 3:10 AM
    Tuesday, April 24, 2012 6:56 AM
  • I use VS 2008 and SQLServer 2008R2, and SSIS (Reporting)

    I have rpt Project in VS 2008, and I manage rdl files.

    I would like use VS 2010 or VS 2012 with SSIS and SQLServer 2008R2.

    Any alternative solution to do it ?

    I have seen, but I'm confused it

    http://stackoverflow.com/questions/12503976/how-to-edit-ssrs-2008r2-reports-in-visual-studio-2012/16112721#16112721

    Wednesday, January 21, 2015 10:48 AM
  • It's either SSIS for creating packages, or SSRS for reporting.
    Which one are you using?

    There is no backwards compatibility for SSIS. If you have SQL Server 2008R2, you need to use VS2008 (the shell alone is enough, no need for the entire product).


    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

    Wednesday, January 21, 2015 11:06 AM
  • In my company, I use VS 2008 and SQLServer 2008R2, and I have rptproj projects in VS 2008.

    The rptproj project has several rdl files.

    Iko says

    You can now use Visual Studio 2010 to edit .rtproj report projects and .rdl reports.

    You need VS10 SP1, then install the Data Tools for VS10, followed by the installation of SQL Server Express 2012 with Reporting Services and Data Tools.

    Reference: http://stackoverflow.com/a/14599850/206730

    But I'm confused about it.


    www.kiquenet.com/profesional

    Wednesday, January 21, 2015 11:40 AM
  • I think you can use VS2010 for SSRS reports on SQL 2008R2.

    Just install the VS 2010 shell (aka BIDS aka SSDT-BI) from the SQL Server 2012 installation media.


    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

    Wednesday, January 21, 2015 11:47 AM