Solved

issue with sql server integration services

Posted on 2016-10-28
6
81 Views
Last Modified: 2016-10-29
Hi. I previously installed SQL Server 2014 express solution express edition. At that time it was free. Can I add SSIS services to the express edition. I have an error message "sql server 2014 installation media folder". I did not have such issues before.
Currently I have only Query management studio and reporting services.  I need to add intergration services
0
Comment
Question by:mikey018
  • 2
  • 2
  • 2
6 Comments
 
LVL 11

Expert Comment

by:Nakul Vachhrajani
Comment Utility
I don't believe that we can have an Express edition with Integration Services (https://msdn.microsoft.com/en-us/sqlserver2014express.aspx).

If you are just looking to develop SSIS packages and run them in Visual Studio IDE, you can explore using SQL Server Data Tools (SSDT), BI edition.
0
 
LVL 17

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Do you have the setup/Media from where you have installed SQL Ex 2014..?  

Try..

Control Panel
--> Add/Remove Programs
--> SQL Server Version/Instance
--> Click Change
 --> Click Add button
--> <<From the List of Feature Choose Integration Services >>
--> Finish.
0
 

Author Comment

by:mikey018
Comment Utility
That was the first I did. Did not work.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:mikey018
Comment Utility
Nakul. Is this the only option?
0
 
LVL 17

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Do you have SSDT with you? SQL Server Data Tools?
0
 
LVL 11

Accepted Solution

by:
Nakul Vachhrajani earned 500 total points
Comment Utility
The licensing restrictions prevent from deployment of Integration Services when using Express Edition.

What is the core purpose here? Do you want to just create and edit packages (as would be the case in a development environment)? If yes, only having SSDT is sufficient.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
If you don't know how to downgrade, my instructions below should be helpful.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now