Visual Studio 2010 support with SQL Server

re: Visual Studio 2010 support with SQL Server

Nick Foster — Wed, 12 May 2010 07:45:01 GMT

@Jeff Bernhardt

Thanks for replying, but are you saying that VS2010 will only support SSIS for the next version of SQL Server? In that case I'm still going to be stuck with 3 versions of Visual Studio installed.

What would be preferable would be to be able to target a particular version of SQL Server just as in code I can target a particular version of the .NET Framework.

re: Visual Studio 2010 support with SQL Server

Jeff Bernhardt — Thu, 06 May 2010 01:42:09 GMT

@Nick Foster

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.

Jeff Bernhardt

Product Unit Manager

SQL Server Integration Services

re: Visual Studio 2010 support with SQL Server

Web Development Tools Microsoft — Thu, 06 May 2010 01:25:02 GMT

@Nick Foster

Thank you for your feedback. I've forwarded your comment to the SSIS team and they have informed me that they are aware of the issue you and other customers have around the lack of SSIS support for VS2010. I can't make any promises but they are formulating a response to the issue.

re: Visual Studio 2010 support with SQL Server

husle — Wed, 05 May 2010 12:53:08 GMT

Benefits of SQL Server Reporting:

1: Create applications to manage one or more report servers through the Web services interface.

2: Create additional rendering, delivery, and data processing extensions using the Microsoft.NET Framework.

3: Create applications that generate reports using the Report Definition Language (RDL).

4: Create applications that embed or link to a Web browser to present and manipulate report output through URLs.

re: Visual Studio 2010 support with SQL Server

Nick Foster — Tue, 04 May 2010 13:10:39 GMT

What about support for SSIS projects of any flavour? So far I have VS2010 installed for coding, VS2008 for SQL2008 SSIS projects and VS2005 for SQL2005 SSIS projects.

If VS2010 can support both SQL2005 and SQL2008 database projects why do I need 3 versions of Visual Studio installed because I have SSIS projects to maintain?

re: Visual Studio 2010 support with SQL Server

Federico — Mon, 03 May 2010 07:36:50 GMT

But unfortuately it seems, that Reporting Services Projects are not supported in VS2010. Neither from SQL2005, nor from SQL2008. I hope you plan to do this soon.

re: Visual Studio 2010 support with SQL Server

Vikram — Mon, 03 May 2010 06:59:28 GMT

hi there,

thanks for sharing this article. It really saves my days trying to solve the problem with my VS2010 tool and SQL 2000. I managed to upgrade it to SQL 2005 and I did not experience this error anymore.

For those who requires to host their VS2010 (ASP.NET4.0 Framework) site, you can always go with ASPHostCentral (http://www.asphostcentral.com). They are truly an ASP.NET expert! Two thumbs up!

re: Visual Studio 2010 support with SQL Server

John David — Mon, 03 May 2010 05:46:31 GMT

On some operating systems this requires one reboot followed by a login and automatic continued installation, on some it requires two reboots.