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:
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.