I have a source component pulling data from an api and pushing it to an ADO.NET destination (from Kingswaysoft productivity pack). The ADO.NET destination is configured to redirect errors to a derived column and then to an error log SQL table, but fails to do so and instead errors out with this. I don't understand why the redirect rows setting on the ADO.NET destination is not working.
The error that I receive is:
"KingswaySoft.IntegrationToolkit.ProductivityPack.DatabaseServiceException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. (Detailed Message: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.) (SSIS Productivity Pack, v21.2.1.35101 - DtsDebugHost, v15.0.2000.180)System.InvalidOperationException
