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