This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/
This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx