Data Conversion error after redirect row on OLEDB Destination

• rs80

  SSCrazy

  Points: 2312

  More actions

  April 25, 2013 at 3:14 pm

  #292749

  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 [9010]] 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.

• rs80

  SSCrazy

  Points: 2312

  More actions

  April 26, 2013 at 8:17 am

  #1610399

  I was able to get this working by doing a data conversion prior to the oledb destination. And then storing the data conversion column in the table. I don't understand though why I can't do the data conversion after the oledb destination.

• simon.David.alex

  Newbie

  Points: 7

  More actions

  August 21, 2014 at 3:55 am

  #1739820

  Hey

  I got the same probleme and I found an other solution :

  I use a sort component which alow you to make a cast after it with a drived column.

  Have a good day