Hi,

obviously, there is a problem with trying to input a big peg in a small hole - when I need to figure out which column is the offending one, I would normally hardcode known accepted values for each column and then (1 by 1) replace the hard coded values with the params and see at which point it throws up the error.

Alternatively, you could do some data profiling on your input data and compare the max sizes against your column definitions (of the target table).

You could also first get the data into a temp table to aid you with the data profiling.

HTH,

B