In Surrogate Key generator stage ,use Bigint...and the same in your Database table,from the error it seems that in Database you are using Smallint and hence the problem come.Surrogate Key generator stage always generates Bigint.so change your Database column datatype accordingly.