Call SSIS remotely to run exe task in server by C#

I would like to build a C# program to connect to a remote SQL2005 server.

Then call the server SSIS to run a .exe in the server (The .exe file already exist in the SQL2005 server)

I have refer to the following webpage http://www.codeproject.com/useritems/CallSSISFromCSharp.asp

I can connect to the SQL server by the "LoadFromSqlServer" method with SQL server login A/C.

However, the SSIS failed. I believe it should be due to the window authentication issue. During SSIS execution, the SQL server login A/C does not have the access right to run the .exe file

Could anyone suggest the solution?

Thanks.

If you are running the C# executable on your computer, it is not running the SSIS package on the server,it is executing it locally. So it would be running under your account, or it may be that the .exe on the server is not visible from your computer.

To actually run the package locally on the server, you'd need to create a web service, or use SQL Agent to run the package. This post from Michael Entin has more details: http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx