如何知道 SSIS 是否安装在我的 SQL SERVER 2008 R2 中 [英] how to know if SSIS is installed in my SQL SERVER 2008 R2

问题描述

我有 sql server 2008 r2，我想把我的存储过程放在包中，我在互联网上搜索，我看到我必须为此安装一个来自微软的数据工具.但是这个工具需要在 SQL SERVER 2008 R2 中安装 SSIS，我怎么知道我是否有它?谢谢你

I have sql server 2008 r2, I want to put my stored procedures in packages, i search the internet , i see that i have to install a data tool from microsoft for that. but this tool needs to be SSIS installed in SQL SERVER 2008 R2, how do i know if i have it ? thank u

推荐答案

您可以转到 SQL Server 配置管理器(通常在开始>Sql Server 2008 R2> 配置工具中可用).一旦启动，您就可以访问所有可用的服务.如果有 Sql Server Integration Services 10.0，您可以右键单击它并启动它(如果它尚未启动).否则，您将不得不前往安装中心并添加此服务.

You can go to SQL Server Configuration Manager (usually available in Start>Sql Server 2008 R2> Configuration Tools). Once launched, you have access to all available services. If Sql Server Integration Services 10.0 is there, you can right click it and start it, if it's not already launched. Otherwise, you will have to go to the installation center and add this service.

SSIS 在 Sql Server 版本上不可用.例如，它在 Express 上不可用.您可以使用 以下查询:

SSIS is not available on Sql Server editions. It's not available on Express for example. You can check your edition with the following query:

SELECT SERVERPROPERTY('productversion'), 
       SERVERPROPERTY ('productlevel'), 
       SERVERPROPERTY ('edition')

这篇关于如何知道 SSIS 是否安装在我的 SQL SERVER 2008 R2 中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！