Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

Visual Studio 2013 cannot open SSIS projects

I have a few SSIS projects that were written using VS 2010 and VS 2012 and when I try to open them using Visual Studio 2013 all I get is incompatible project. I downloaded the SSDT for VS 2013 but that did not help. Is there any way to get VS 2013 to open SSIS projects?
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

I have had this issue myself on occasion.  I typically find it easier to create a new solution/project and add the packages as existing items as opposed to trying to make the older solutions/projects work in the new environment.

Maybe someone else has a silver bullet fix that I'm not aware of though.
Avatar of rwheeler23

ASKER

I would try that if I could. If I click New Project I do not get the option for Business Intelligence and hence no option for an SSIS project. What the heck am I missing?
ASKER CERTIFIED SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It took me a while but I believe I had stumbled upon this one. It is odd that these tools are not part of the basic SQL installation. Thanks for the tips.
They are part of the install but they aren't included by default.
SSDT has been removed completely from SQL Server 2014.
Thanks