Getting Error "The conversion of the varchar value '6160382514d97' overflowed an int column" in an SSIS Package

user_17250538 0
Viewed 104

I have been searching for a solution to this and haven't had any luck.

I have an SSIS package which is loading data from one table and after some lookups, etc. writes it out to another table. The above error is occurring during the first step of the Data Flow which is an OLEDB Source (SQL 2016 db). The column in question is an nvarchar(250) and there is nothing that changes it to an int at any point.

I'm thinking that it must be some sort of implicit conversion, but why when it is nvarchar all the way through?

I'm pulling my hair out with this, does anyone have any ideas please?

Data Flow

Error Message

Source and Destination Metadata

visual-studio-2019 ssis sql
2 Answers

Thanks for the responses. The issue seems to have been a buffer size issue with with a lookup task. When I checked the lookup table, it didn't have an appropriate index. I have added one and it seems to have solved the issue.

user_172505380

Sometimes SSIS keep the old metadata with the auto-convert.

I suggest that you delete your ole Db source component and rebuild a new with your select. Moreover you can go to advenced option (right click on the source component and in the last tab you can validate the datatype of your column and adapt to varchar if it is integer.

user_97173650
Related