DTEXEC for remote execute

I have a legacy extraction ("E") .NET 1.1 application that is still going to be the driving force for our ETL process. We are going to be utilizing SSIS for "T" and "L". Now, the "E" phase is running on an application server where we have .NET 1.1 framework installed and working. The SSIS packages are running on a separate SQL Server. The problem here is - how do we call the SSIS package and be able to pass in the right parameters from this .NET app that runs on a separate box? We would like to use DTEXEC to call the remote SSIS packages through Integrated Security. The SSIS packages are stored as File System packages.How about calling the SSIS package(s) via a stored procedure?|||Ok, I was wondering if there was a more efficient way of executing the SSIS package from the remote server without having to go via a stored procedure.|||

yosonu wrote:

Ok, I was wondering if there was a more efficient way of executing the SSIS package from the remote server without having to go via a stored procedure.

Search this forum for the two words "dtexec" and "remote."