Importing Date from Excel to SSIS

Hi Everyone,

I am trying to fetch date from Excel source, by default the excel column is in UK format but when the date is given in anyother format, it returns NULL.

I want excel to return date in any of these format to my ExcelSource in SSIS:

20120125

25/01/2012

01/25/2012

01/25/2012 00:00:000

25/01/2012 00:00:000

25012012 00:00:000

Thanks in advance

You will probably need to convert the date to a string and then manipulate the string. Here are some blogs I wrote that might help.

http://www.bidn.com/blogs/MikeDavis/ssis/171/converting-date-and-time-from-db2-to-sql-in-ssis

http://www.bidn.com/blogs/MikeDavis/ssis/312/ssis-convert-string-to-date-no-dashes