Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ying Zhang How to Handle NULL Values Loaded by SSIS from Excel Files RE: How to Handle NULL Values Loaded by SSIS from Excel Files

  • January 5, 2010 at 4:39 pm

    #1099309

    Use a derived column to convert the datestring to the format yyyy-mm-dd RIGHT(thedate,4) + "-" + SUBSTRING(thedate,4,2) + "-" + SUBSTRING(thedate,1,2) as a unicode string (DT_WSTR) then convert that (data conversion) do a date (dt_date). This is what works for me.