CODEWITHSUNDEEP
c#sql-serversql-server-2005ssisssis-2005
Luther
Luther

Reputation: 87

Executing SSIS package on SQL server 2005

I am working on upgrading legacy applications that used DTS packages. This is the first time working with SSIS packages.

The application (which lives in various places) will need to invoke and execute an SSIS package that is on a SQL 2005 server. So relative path do not work for me since someone in New York would need to access the same Server via the application and get the same results back. We are also keeping a log of everything that happens throughout the transaction. The only option left is to create a stored procedure and get the stored procedure to kick off the SSIS package but I feel as though we may lose logging capabilities then. How do I execute the SSIS package remotely using C#.net?

I've already looked at the Microsoft solutions of execution and they don't work in my instance. Doing a SQL Server Agent schedule is out of the question.

Upvotes: 2

Views: 135

Answers (1)

Hadi
Hadi

Reputation: 37313

I think the best way is to create a stored procedure to run ssis packages, and you will not lose logging capabilities because you can get all outputs sent by the package.

The following links contains example on executing packages from sql server and from external files using stored procedure:

Upvotes: 1

Related Questions