Hi,

I have a problem with a derived column. There is a txt file that I load to the database using SSIS. Before the load I have to convert one of the columns into integer because it's what should be used in the db. There are nothing but integers there, but I still receive an overflow error for all numbers >= 32768. I tried all integer types in SSIS, also numeric and float, and still get the same error, so I guess it's a problem with buffer size or something else that does not understand integers higher than 2^15.

How can I fix it? All your ideas are highly appreciated.

V.