Value was too large or too small for an Int32 is a very common error in SSIS. The problem is related to a number or a data type that is too large for the data type used.
Usually, the problem happens when the data type is too large for an Int32.
What is an Int32?
It is a data type with a range between -2,147,483,648 to 2,147,483,647. If the value is outside this range, the error message will be displayed.
If you are using our ZappySys components, this problem should be solved in the last version. Try to install the last version of our product.
If solution 1 does not work, try to change the data type to int64 or another datatype that accomplishes your needs.
The int64 has the following range: -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807