Installation of IS to Server

Hi,

Is there a need to install the Integration Services to a Server? Isn't it enough to just port the .dtsx file from my local drive to the server and execute it by SQL Agent using DTExec /f command?

thanks,

cherriesh

cherriesh wrote:

Hi,

Is there a need to install the Integration Services to a Server? Isn't it enough to just port the .dtsx file from my local drive to the server and execute it by SQL Agent using DTExec /f command?

thanks,

cherriesh

You won't have dtexec.exe without installing SSIS. And SSIS is required to be installed regardless, as dtexec.exe would require the SSIS dlls to execute anyway. SSIS isn't redistributable like the old DTS was.