SQL Server Integration Services are missing in SQL Server 2014 installation

Question

I am trying to install SQL Server 2014 with Integration Services.

Here is the download link I used to download with tools.

File Name : SQLEXPRWT_x64_ENU

But when I proceed to feature selection Integration Services is missing ?

What am i doing wrong ?

Any help would be great.

Update

For future readers, Actually Integration Services is not available on sql azure as said by @Nick.McDermaid , and i was trying to export sql query results to excel. I have to try some other options for sql azure. But Integration Services must be available in other sql server products.

Answer 1

Take a look at this page:

https://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx

Under the heading

Integration Services

You'll see Express with Advanced Services has:

• SQL Server Import and Export Wizard
• Built-in data source connectors

But it doesn't have

• SSIS designer and runtime

So the answer is no: express with advanced services does not have the full SSIS version, therefore you won't see it in the install tick boxes. It does have import/export wizard

SQL Server 2016 Development edition is free and comes with SSIS

To transfer data from Azure to a local excel file I can think of three options off the top of my head:

• Manually, run a select query in SQL Server Management Studio, then copy paste the grid into Excel. Or you can right click/Save results as CSV

• You should be able to use the import/export wizard on your local install of SQL Express to extract data from the Azure instance. I've never tried it though

• If you want to automate it you can use SQLCMD to export a CSV file also

The next question is why do you want to export it? If it's for analysis you might be better served running SQL Queries. If it's for a report, again you might be better served with SQL queries or whatever bits of SSRS are installed with SQL Server Express Advanced