Post reply

Data Conversion error after redirect row on OLEDB Destination

  • 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.

  • 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.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply