Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Conversion error after redirect row on OLEDB Destination Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 3:14 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 8, 2014 7:57 PM
Points: 99, Visits: 308
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.
Post #1446734
Posted Friday, April 26, 2013 8:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 8, 2014 7:57 PM
Points: 99, Visits: 308
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.
Post #1447026
Posted Thursday, August 21, 2014 3:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 7:26 AM
Points: 1, Visits: 1
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
Post #1605727
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse