Project type .dtproj is not supported by this version of the application

Question

Good afternoon.  I have been trying to install and do some preliminary evaluation with SQL Server data tools.  I have repeatedly run into the following error when I try to open an existing SSIS project to test upgrading it:

<Path> 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 object.  

In addition, I do not have the SSIS menu that I've seen in various demonstrations and web casts in the visual studio environment.  I've re-installed several times, including removing all instances of visual studio 2010 from my system, at one point.  When I did that, I did see the installer go out and grab the 2010 shell, but it ended up with the same result.  I'm sure I'm missing something obvious.  Has anyone else come accross this?

Thanks!

Answer 1

Hello,

Have you opened to SSIS solution (sln file) with a double click in Windows Explorer? If you haven't installed the previous version of BIDS this don't work, because the "Visual Studio Selector" reads the version from sln and want's to open the right version of VS/BIDS, which isn't installed on your machine.

Start SSDT directly from Windows start menu and then open the solution from the SSDT file menu, selecting the SLN file. SSDT will recognize, that this solution is a previous version and upgrade it then.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Thanks for the reply.  Unfortunately, I was not opening it from windows explorer.  I am launching SSDT from the start menu item placed in the root of the start menu.  I verified that this item was not there when I uninstalled SSDT.  From there, I attempt to open the solution from the SSDT file menu and get that error.  It's almost as if I'm getting the shell component, but the data tools are not getting attached to it properly :/.

Answer 3

Trev, 

It appears that you are attempting to leverage SSIS functionality to open an Integration Services project. As this is a forum primarily for the Database Project portion of SQL Server Data Tools, please redirect your question to the SSIS forum here - http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/threads/. They will be able to answer your question regarding SSIS installation more quickly and accurately. 

Thanks,

Adam

---

Adam Mahood - Program Manager - SQL Server Data Tools

Answer 4

Sure thing, sorry about the mix-up!