How to format datetime properly in copy activity. Receiving error when copy activity due to formatting


  • I have a copy activity from blob to sql server.  During this activity, I get an error 

    Message=Column 'sys_created_on' contains an invalid value '"2018-10-30 20:12:25 PDT"'. Cannot convert '"2018-10-30 20:12:25 PDT"' to type 'DateTime'.,

    My question is, how do I get this formatted correctly. I think it is the PDT that needs to be scrubbed. I see a format option, but not sure what to put in there. Any help is appreciated


    Wednesday, October 31, 2018 2:35 PM

All replies