The Error HRESULT E_FAIL has been returned from a call to a COM component. There are some required fields in the Target database. The source data does not have all the data. You need to update the source to have the required fields for the target database.