I was able to do this via SSIS by setting the data type on the destination table to datetime2(7) then letting SSIS assign the default string(50) datatype to the field. You'll get a truncation warning when setting up the mappings/conversions, but if you set to ignore they will still import. You don't get a warning-free package completion result, but the data will import. One other note. When setting up the package via the wizard, it would not let me execute the package upon wizard completion (could only save it). But I executed immediately after - again with a few nasty warnings - but the import completed.