• dan-572483 (9/28/2013)


    By "install SSIS" I mean the Integration Services checkbox in Setup.

    So it sounds like it doesn't need to be on installed on the Database Engine server if a package is being run from a client machine that has SSIS installed and is connecting to the server.

    What if you want to schedule a data import package in SQLAgent. Do you need to run Setup on the server with the Integration Services box checked in that case?

    Yes. You need to install Integrations Services on every machine that will run a SSIS package.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP