SQL Insert Question

I wanted to know if it is possible to make the map insert into SQL when the node length is longer that the table field it is inserting it into.

For example in Sybase when when a variable is passed in like Middle Name  and in one of our tables it only has the middle initial so sybase has an option to auto truncate to the maximum size of the field.

I know what your thinking either do a string trim or make the table field larger.

The problem is I have mapped an entire 837 and I get this error binary or string data is to long and will be truncated and it does not tell me which field it is on. It does not give me the error on every file so I know it is just one field and I am looking for a easy way to just map the truncated data so I can easily find the column that is causing it.

I am validating the map so I know it is a valid length.

Hopefully someone has some good news for me.