Home > Logging, SQL Server, SSIS, SSIS 2008 > FAQ: what is the purpose of turning on the service”SQL Server Integration Services”?

FAQ: what is the purpose of turning on the service”SQL Server Integration Services”?

February 11, 2010 Leave a comment Go to comments

This is a very common question asked to me by many developers. As a fresh developer few years ago, even I used to wonder about this service. The SSIS packages used to work perfectly with and with out the services being turned on (Start).

So what exactly does the SSIS service do?  The answer is simple.  The SSIS Service  manages the Integration Services server and its interface in SQL Server Management Studio. It also provides caching of SSIS components. The SSIS services is required to import/export packages, view running packages, and view stored packages in the “package store”.

SSIS services has nothing to do with the execution of packages. The package execution is controlled by package execution utility(dtexec). The services does not have any impact on

  • SSIS package development
  • SSIS Package  execution
  • SSIS Package performance 
  • Checkpoint restarts
  • Logging fuctionalities.
Advertisements
Categories: Logging, SQL Server, SSIS, SSIS 2008
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: