SSIS Data Flow Task with Export to Excel 2007 xlsx Destination doesn’t retain the datatype from Source

In this blog post, I would like to address one typical limitation in SSIS Data Flow task which many of us might have experienced when you export the data to Excel 2007 (xlsx) Destination which has also been reported in the following connect item https://connect.microsoft.com/SQLServer/feedback/details/477970/excel-data-types-from-ssis It is actually a limitation of ACE Provider in the…