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.
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)
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
- Edited by Kiquenet For Forums Wednesday, January 21, 2015 10:49 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).
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.
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.
But I'm confused about it.