how to know if SSIS is installed in my SQL SERVER

问题:

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

this is my sql server 2008 r2

回答1:

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 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')