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

qbjgqbjg
qbjgqbjg used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
qbjgqbjgConsultant

Author

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 Analyst
Top Expert 2015

Commented:
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.
qbjgqbjgConsultant

Author

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.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Business Intelligence Developer and Analyst
Top Expert 2015
Commented:
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.
qbjgqbjgConsultant

Author

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 Analyst
Top Expert 2015

Commented:
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
qbjgqbjgConsultant

Author

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.
qbjgqbjgConsultant

Author

Commented:
I am going to close this question until they try installing this again.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial