Using SQL Server 2008 Integration Services.
In the oledb destination I have set data access mode as Table or View and have set a redirect row to a exception table. The field that I need to insert is type DT_STR and the exception table expects the field as DT_WSTR. So after the redirect row I added a Data Conversion to convert the field from DT_STR to DT_WSTR. But I get the error below:
[Data Conversion ] Error: Data conversion failed while converting column A to column B . The conversion returned status value 8 and status text "DBSTATUS_UNAVAILABLE".
I tried to convert other columns from DT_STR to DT_WSTR, but get the same error. If I don't include any fields from the oledb destination and just sample text then the record gets inserted successfully in the exception table.
Is there something I need to do the fields after a redirect row?
When doing a table or view - fast load there are no issue with the data conversions.