Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 7 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
add comment

Your Answer

 
discard

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.