I've created a C# Windows app that executes packages remotely.

It's basically like that:

_package = _app.LoadFromSqlServer(packageName, _server, null, null, null);

_result = _package.Execute();

But of course the package I run runs another package that it has its local path to on the server c:\packages\package.dtsx

So it I get an error on my local machine as the package doesn't exist locally on my machine...

So is there a way of executing package from a package that the executed (child package) is located on SSIS storage and not on the c:\packages ???

What I would like to happen is that when I execute the remote package it would call what ever it wants to call but not look for it on my local machine.

Any advice is greatly appreciated!

Thanks,

-Arek

Hi Arek,

Based on the document, we can load a package programmatically on the local computer, whether the package is stored locally or remotely with LoadPackage, LoadFromDtsServer or LoadFromSqlServer method.

Besides, we can also run a remote package on a remote server in multiple ways:
Use SQL Server Agent to run the remote package programmatically
Use a Web service or remote component to run the remote package programmatically

For more details, please see:
Loading and Running a Remote Package Programmatically

Thanks,
Katherine Xiong