Best way to start SSIS catalog or SSIS package remotely

Question

I need to execute an SSIS package or an SSIS catalog remotely. What is the best way to acomplish this?

I’m using:

Visual Studio 2012 SQL Server 2012

Answer

I am almost positive you need an integration server to accomplish this. The package is stored in the MSBD of the integration server and called by job or execution statement from within your code.

Siting MSDN http://msdn.microsoft.com/en-us/library/ms403355.aspx

Accepted Answer

I am almost positive you need an integration server to accomplish this. The package is stored in the MSBD of the integration server and called by job or execution statement from within your code. Siting MSDN http://msdn.microsoft.com/en-us/library/ms403355.aspx

Advertisement

Answer