1

I have brand new Windows machine which we are planning to use as production machine to run our SSIS packages. My pacakges are on filesystem not in SQL Server. Is it possible we can install SSIS Engine only without BIDS. Will utility like dtexec work if We install only SSIS Engine? Is it a good idea?

Pritesh
  • 1,938
  • 7
  • 32
  • 46

1 Answers1

3

In Production you wont be developing the SSIS packages so you don't need BIDS .

BIDS is a plugin for Visual Studio with additional Project types that are
specific to SQL Server business intelligence.

While installing SQL server you should include Integration Service Instance.SSIS runtime is actually not needed to run your packages . SSIS Service Usage

Check out this article

Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service

dtexec utility comes with SQL Server to run a SQL Server Integration Services (SSIS) package .So even without BIDS ,this utility will run your SSIS packages

praveen
  • 12,083
  • 1
  • 41
  • 49
  • I am planning not to install SQL Server DB Engine also, while isntalling if I select only checkbox for Integration Services will I be able to run pacakges through dtexec? – Pritesh Sep 12 '12 at 08:31
  • 1
    You need to have server license in order to run DTEXEC utility.So management studio is essential but Server server DB engine is not needed – praveen Sep 12 '12 at 08:35
  • so SSIS Engine + SSMS in production will be enough? – Pritesh Sep 12 '12 at 08:44
  • 1
    Yes .To summarize you just need DTEXEC utility to run your package in Production.and that utility gets installed when you pick the "Integration Service Instance" option while installing.Hope that clarifies your doubt – praveen Sep 12 '12 at 08:48
  • Is there any Harm in also installing BIDS?? – Pritesh Sep 12 '12 at 08:53
  • There is no harm, because you can choose which services gonna run. How you gonna configurate packages on the machine without BIDS? There is already connections and etc? – Justin Sep 12 '12 at 08:57
  • There should be some use of installing BIDS in production rit ? Always packages are created in dev and then deployed in prod .Generally these packages are executed in prod using SQL agent or by C# or VB application.It generally a good practice not to install BIDS in prod as you don't want any one in production to open your SSIS package using BIDS and mess around with it. – praveen Sep 12 '12 at 08:58
  • @Justin : Package Configuration are generally done using Environment variables ,XML file or sql server .So to configure any of these ,you don't need BIDS – praveen Sep 12 '12 at 09:17