Link to home
Start Free TrialLog in
Avatar of qbjgqbjg
qbjgqbjgFlag for United States of America

asked on

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?
Avatar of qbjgqbjg
Flag of United States of America image


I need to add, I am talking about being able to edit with the normal design view not an XML edit.
Avatar of Arifhusen Ansari
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.
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.
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I do not see it. Everything I am reading says that with sql 2014, SSIS is a separate install.
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.

User generated image
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.
I am going to close this question until they try installing this again.