Sorry for the late reply, I've been busy trying to get this thing working.

Do you think that might be because I am using SSMS 2012? I can use another version if need be.

I'll try another very simple package that copies from one sql table to another table w/o the user of SSIS.Pipeline.3

Can you upload a dtsx file that works for you?

Ultimately, here is my issue... I am trying to create a solution that would take any number of sql statements and export them as separate sheets/tables to Excel/Access via SSIS API (building a package on the fly) or SSIS package (where the package already exists with params being passed to it via .net code).

I have a solution that works like a charm using the old DTS API. I was able to work it out by saving the DTS package as VB Script (the old SQL Server allowed us to save it like that). Then I took the VB script and turned it into .Net code... easy breezy... then comes SSIS and I no longer can do such a gimmick, thus having to learn the API from the scratch, which is insane. So, I figure, there has to be a way to decompile the dtsx into C#/VB code and see the step by step I need to take to get to a solution.

That being the context of why I am trying to use your solution as a guide, let me know if you think of any other way that I could try to get to a solution. That would be very very helpful. I've been beating my head against this wall for 3 weeks now :). In fact, I was able to export one table to Excel tab, but the code fails when it tries to export 2 tables. Ugh...

Thanks

Stefan