Hi All,

I think I have figured out what was going wrong. Actually I was getting this "CRAZY" error messages when my DynamicPropertiesTask was trying to set some properties for OLEDB Connection...

Thanks John,

This piece of code was really helpful. I created Excel.Application instead of Excel Sheet object.

Kind Regards

Prashant