I am moving towards some VBA in the book itself. The user can choose to reformat and pretty-up the report if desired. It keeps the SSIS task thinner and the...

This looks like the right solution but I have not gotten it to work yet.

http://www.vbcity.com/forums/topic.asp?tid=76537

When I try using the END keyword I get an error message. A google yields the following:

http://msdn.microsoft.com/en-us/library/686w7tx3.aspx

'End' statement cannot be used in class library projects

Updated: November 2007

Class library...

Okay, thanks for the update.

Did you ever figure out the solution to this problem?