Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On a SQL Server 2005 instance in our DMZ, we have BIDS installed but not the SSIS service.

If I have an SSIS package on that server, can I still schedule to run it without SSIS service?

I tried using DTexec but it is not able to find the package.

share|improve this question
up vote 10 down vote accepted

The SSIS service doesn't actually do much and you can run packages without it or with it disabled. It's used by SSMS amd SQL Agent for example.

See the KB article "Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service"

What you need are the base SQL Server binaries which are installed with the DB engine. So you need a SQL Server Instance of some flavour to have dtexec running. Whether it's the DB Engine or the SSIS service installed but disabled.

Running packages in BIDS is a special case. Run the package on the same PC as BIDS via dtexec and it will fail unless you have installed server components (= a SQL Server Instance)

share|improve this answer
thank you very much – Manjot Aug 31 '11 at 3:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.