Recently while writing an SSIS package, we were getting the below exception. System.Exception: Error: Failed to set field ‘birthdate’ value to ” for entity ‘contact’ (field type: DateTime, value type: String). System.FormatException: String was not recognized as a valid DateTime. (SSIS Integration Toolkit for Microsoft Dynamics 365, v10.2.0.6972 – DtsDebugHost, v14.0.3025.39) We were getting the … Continue reading "How to – convert a blank string to Null for DateTime field – SSIS"