SSIS - Recently installed 2014, now edit not on menu in file system

Our packages are stored in the file system. Prior to having sql 2014 installed we had 2008. I could right click a package and edit was in the menu. Now it isn't. How do I get it back?
qbjgqbjgConsultantAsked:
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.

qbjgqbjgConsultantAuthor Commented:
I need to add, I am talking about being able to edit with the normal design view not an XML edit.
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
It's not a great way to open any package directly from file system. Instead you can do better way.

1) When you install SQL2014. You might have install the SSDT( Sql server Development Toos).
2) Open SSDT. Go to -> File Menu -> New -> Create Project -> Select "Integration Services Project" Template.

3) When you click Ok your project is ready.
4) Go to Solution Explorer -> Right Click  SSIS Package folder select add existing Package. Select your package form the file system. You are done. Your package will be added in the solution.
You can directly deploy from here.

It's good way to manage packages by adding them in one solution.
qbjgqbjgConsultantAuthor Commented:
I am not the person doing the install.I don't believe they did the install needed to create and edit SSIS packages. I understand that you do not like the method we have been using, However I would like to know if we can still use it with SQL 2014? They will be looking at doing that install today.
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Just go to Program search and type "SQL Server Data Tools" if you find application this means ssdt is install.

What my impression when you install sql 2014, SQL Server Data Tools will be installed.

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
qbjgqbjgConsultantAuthor Commented:
I do not see it. Everything I am reading says that with sql 2014, SSIS is a separate install.
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Have you installed the SSIS along with SQL 2014? It's an separate service in sql server.
So during installation you have to select that feature to be installed.


2016-03-25_19-31-23.png
qbjgqbjgConsultantAuthor Commented:
Since I did not do the install, I can't be sure. But I am unable to find anyway to create or edit a package. So, my belief is that it was not loaded.
qbjgqbjgConsultantAuthor Commented:
I am going to close this question until they try installing this again.
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
SSIS

From novice to tech pro — start learning today.