Executing A Package From Within A C# Program Returns Failure Everytime

Hi All,

I am trying to execute a package (programmatically) that is stored on my local disk using the information that is provided on the following page:

http://msdn2.microsoft.com/en-us/library/ms136090.aspx

This means, I am using the Application object and the Package object to actually load the package using the path to it.

So my code looks something like this:

-----

pkgLocation = @"<package_path>/Package1.dtsx";

app = new Application();



pkg = app.LoadPackage(pkgLocation, null);

pkgResults = pkg.Execute();



Console.WriteLine(pkgResults.ToString());



Console.ReadKey();

---

My package reads in a flat file (located on another server) and transforms it and saves it to a database (on that same server). And mind you, I can execute this package just fine when I do it manually from within BIDS.

But when I try to execute the above mentioned code in my C# solution (compiled to a command line executable), I always get a "Failure".

Can somebody point out what I am doing wrong here?

Thank you in advance,

Manan Pancholi