Scenario:
- Source: ADO.NET (SAP) [Server Src]
- Destination: OLEDB (SQL Table) [Server Dest]
- Process: Loading data from SAP Source Object to SQL Table. Source contains ~3 Million records. It loads almost ~1.8 Million and then it fails with Error mentioned below. I have tried a workaround where, I have used 2 data flow tasks; 1st with a where clause stating [WHERE <Attribute_Name> NOT LIKE '%''%'] and 2nd with [WHERE <Attribute_Name> LIKE '%''%']. This workaround is working fine. But whenever a single data flow is used this is failing with same error as mentioned.
- Error: [ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. Field <Attribute_Name> is missing an escape character for a quote.Unable to update PK WHERE clause.Error processing data batch.