Getting return value from package

Question

I have an SSIS package that imports data into a table.

My programmer wants to be able to call my SSIS package from his code and then he needs to recieve a value as to if the package was succesful or not.

How do you do that?

---

qeqw

Answer 1

See: http://msdn.microsoft.com/en-us/library/ms403355.aspx#agent for an example.

Regards,
Ivo

Answer 2

 Application app = new Application();
 Package pkg = app.LoadPackage(PackageName, null);
 pkg.Execute()

then check pkg.errors to see if there is any error during execution.

 

You can read the following articles for the details

http://www.codeproject.com/KB/database/CallSSISFromCSharp.aspx