Excuse me but I believe that I said the same thing?

You are very limited with this task.

I'm not sure about training but there are several articals about how to accomplish this objective:

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

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

http://www.networkworld.com/community/node/31742

http://www.mssqltips.com/tip.asp?tip=1462

Does this help or lead you in the right direction?

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/f60cbb51-bf6b-4b6a-b30e-db3096355392

Can you check your local machine, to determine that both the client Server Component as well as the OLEDB Providers to determine that it is not a 32/64 bit...

You may need to use a distinct, group by or subquery to get the intended result.

Please refer to the posting guidelines but it sounds like you may need an OUTER JOIN and/or a UNION, etc but without providing the information as stated in the posting...

I found the Database Mail Task to be limited and the SQLCLR and Script task to be more robust.

I'm not a fan of SQL Mail either and I never worked anywhere where we were allowed to use it.

SMTP was the standard and I used ActiveX Scripts to accomplish...

Are you running from a job or from SSIS?

I have not had any problem identifying which process is running a Package but perhaps I'm missing something.

I first identify the SPID,...

This problem will occur when running in 64-bit mode whit the 32 bit Informix Client components installed.

Please verify installation.

Have you tried executing the SQL Command outside of the SSIS PAckage?

There are several logs that you can use and can be helpful.

I have experienced issues with mixing 32 bit...

Have you tried creating the Cluster though the GUI?

Once you have the process down then you may have better success and/or you may find it easier to identify what you...

The article listed below may address your question:

http://www.sqlteam.com/article/sql-server-2008-table-valued-parameters

If not let me know, thanks.

I like Elliot's work around, it is very clever.

Listed below is an article that discusses this issue and may be an alternative but I like Elliot's approach. 🙂

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/4554075c-5f68-4e59-9f7c-8d46c05e8ec6

I found another Article that addresses Logging of SSIS Packages:

http://www.sql-server-performance.com/articles/biz/SSIS_Features_And_Properties_Part1_p1.aspx