If you already have a SQL Server 2008 or a SQL Server 2008 R2 instance then do not install SQL Server Denali as a named instance. If you do so then your current SSIS development environment will be broken. There is a reason there are virtual machines, I recommend using VirtualBox
With CTP1 of Denali, BIDS is still based on Visual Studio 2008, in a later version it will use the 2010 shell.
Anyway if you do install Denali as a named instance this is what happens when you try to create a new SSIS project
Here is the text
—————————
Microsoft Visual Studio
—————————
‘C:UsersDenisAppDataLocalTemptemp.dtproj’ cannot be opened because its project type (.dtproj) is not supported by this version of the application.
To open it, please use a version that supports this type of project.
—————————
OK Help
—————————
Here is also a small video I created
Click on the SQL Server Denali tag to see all our SQL Server Denali related posts
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
