Tags for m/d/yyyy
Convert date format m/d/yyyy to mm/dd/yyyy in TPT
I have a file I am loading to a table in my database via TPT. Everything is working properly, however I am dropping records where the date format is m/d/yyyy (as opposed to mm/dd/yyyy). Is there a way, in the insert statement in APPLY to convert the field on the fly via CASE, CAST, or some string manipulation?  
tpt import date format m/d/yyyy