3

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.

11

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)

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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