SQL Agent running SSIS packages

Hi there,

if I have some packages (.dtsx) that are depolyed to Server A and I have SQL Agent installed on Server B - if I run a run a package from SQL Agent, does it run on Server A or Server B

Thanks in advance.



Answer this question

SQL Agent running SSIS packages

  • Maestro1988

    The packages run on the Agent server (B) - i.e. where they are scheduled. The location where the packages are stored does not matter.

  • SQL Agent running SSIS packages