locked
Run SSIS package at scheduled time without running SSIS service RRS feed

  • Question

  • Hello

    I want to run SSIS Package using SQL Agent job, But for some reason, I am allowed to install SSIS services on the server. Is there any way to run SSIS package without running SSIS service? I tried using DTEXEC.exe command, but it still give an error. "To run SSIS package outside SQL server data tools you must install service".

    Thanks in advance

    • Moved by Kevin Cunnane [MSFT] Thursday, August 7, 2014 8:17 PM Moving this to the SSIS forum as it's related to that topic.
    Thursday, August 7, 2014 6:34 PM

Answers

  • Hi Swetha,

    The service itself is not doing much (only allows to connect), but to actually execute SSIS packages naturally you have to have the Integration Services installed where you want to run the package. Likewise, if you have SSIS installed elsewhere you can run it remotely off the local SQL Agent that connects to a remote package.


    Arthur My Blog

    • Proposed as answer by Olaf HelperMVP Friday, August 15, 2014 6:54 AM
    • Marked as answer by Elvis Long Monday, August 18, 2014 7:06 AM
    Monday, August 11, 2014 5:50 PM