server缺少sqlexpress sql,SQL Server 2014安装中缺少SQL Server集成服务

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 ?

xBcBT.jpg

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.

解决方案

Take a look at this page:

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值