SSIS : Convert MM/DD/YYYY into DD/MM/YYYY

SQLServerCentral » Latest topics

SSIS : Convert MM/DD/YYYY into DD/MM/YYYY

Dear all,

I am receiving from a excel file a string with the format (MM/DD/YYYY). I would like to transform it into (DD/MM/YYYY).

Can I do this with a data conversion task or do I need to create a script task?

Thank you

more info...