Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.

SQL Server Developer Center >

SQL Server Forums >

SQL Server Integration Services >

problem with deploying ssis 2010 package

problem with deploying ssis 2010 package

Monday, April 23, 2012 10:04 AM

0
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)
- Reply
- Quote

All Replies

Tuesday, April 24, 2012 6:53 AM

0

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
- Reply
- Quote
Tuesday, April 24, 2012 6:56 AM

0
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 ZhaoMicrosoft Contingent Staff, Moderator Tuesday, April 24, 2012 3:19 PM
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Wednesday, May 02, 2012 3:10 AM
- Reply
- Quote

Frequently asked questions - Forums help