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

asked on

Cannot open SSIS project

I have this one W2012 R2 server that will not open any SSIS projects. The server has SQL Server 2014 with the latest version of SQL Data Access tools installed. When I try to open the projects it tells me it is not  a support type and if I search for SQL Data Access Tools nothing is found. All my other workstations and servers do not have this issue. I have uninstalled and reinstalled several times now and I have loaded the latest SSDT package. What else can a try to get SSDT to run and open SSIS projects?
Avatar of damey
damey

you can try and use the dtsx file from 2012 and replace it with 2014.
Here is a detailed manually way to manually change of values but first simply try using the 2012.  Information and manual process...
http://vaniecastro.com/2015/02/26/how-to-downgrade-sql-server-integration-services-2014-packages-to-2012/
Avatar of rwheeler23

ASKER

Yes, that fixes the project. Any ideas as to why SQL Server Data Tools 2014 is not available? It is not listed as a program option nor can I find it using File Explorer. I have downloaded the last SSDT-2014 update and it said it installed correctly.
In SQL Server Setup dialog box select Feature Selection under Shared Features make sure the SQL Server Data Tools is selected (should be the 4th checkbox in list).
The tools are actually an add-in with little to no documentation.  This applies to both SSDT & SSDT-BI I'm sure you downloaded and installed both already? If no you can get them here: http://www.microsoft.com/en-ca/download/details.aspx?id=42313 <-- lol look at the install instructions....idiots.
So try and do a uninstall of SQL Server and do a repair to go through the set up and make sure the above box is checked (see screen shot) and any other things in the extensive lists that you may want.
I'm not sure if you can add on manually or via add in option somewhere in the menus?
Like the old saying... upgrades are actually down grades and cause us far too much grief.  I'd wait till 2017 or later to install 2014 upgrade, wait till all the bugs are resolve!
3428-MissingFeatures.jpg
I attended a Microsoft conference back in April and ran into the SQL group. When I asked them why this was done the answer was that the SQL group got tired of waiting for the VS group to have their code ready so they detached them from each other. I will check what I find on your link versus what I have already downloaded.
When I install this it tells me the CPU is of the wrong type. It claims to be for both 32 and 64 bit. Is there a 64 bit version of this? Never mind, if you choose the new instance instead of upgrade it installs just fine. Just goes to prove it you click enough buttons things will eventually work out for the better.
ASKER CERTIFIED SOLUTION
Avatar of damey
damey

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
Yes, I have the SQL Server Data Access Tolls back now Thanks for your helpful insight.