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?
LVL 1
rwheeler23Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dameyCommented:
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/
0
rwheeler23Author Commented:
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.
0
dameyCommented:
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
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

rwheeler23Author Commented:
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.
0
rwheeler23Author Commented:
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.
0
dameyCommented:
Sad but true sometimes.  So is this solution completed?  Did you get the SSDT working?
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rwheeler23Author Commented:
Yes, I have the SQL Server Data Access Tolls back now Thanks for your helpful insight.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.