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
you can create integration services catalog and host your project and packages inside it.
Now you can navigate to the package and execute it manually by providing all necessary parameters if any.
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