Hi ALL! @nasreen-akter @MartinJaffer-MSFT @KranthiPakala-MSFT
I have an Array in our json source for a Copy Activity:
"phoneNumbers": [
{
"isPrimary": true,
"type": "Personal Cellular",
"phoneNumber": "440/364-6078"
}
],
I have this mapped as an Array with Collection Reference Checked, and all works great when there is data in the json file for phoneNumbers which is Source.
HOWEVER, today in Final Testing someone created a json file in which this array is like this:
"phoneNumbers":null,
This caused a failure error as follows below. How can I handle the mapping with a null is present in the data file for phoneNumbers like this and overcome this error? The pipeline works GREAT as long as there is "phoneNumbers" data.
I must be able to solve this so that we can Go Live with this pipeline.
Thanks!!
Mike Kiser
Error:
Operation on target Copy SSFEmployeesBlob failed: Failure happened on 'Source' side. ErrorCode=UserErrorTypeInSchemaTableNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to get the type from schema table. This could be caused by missing Sql Server System CLR Types.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.InvalidCastException,Message=Unable to cast object of type 'System.DBNull' to type 'System.Type'.,Source=Microsoft.DataTransfer.ClientLibrary,'