SSIS – Let the Excel connection manager pick the right column data types from an Excel source
The excel connection manager scans every first 8 rows to determine the data type for a column in your SSIS
Tag: Data Type
SSIS – Convert various String date formats to DateTime with the Script Task
The script below is really nice if you need to convert String dates that come in different (unexpected) formats. Just
Jorg Klein's Blog 