If I set the SSIS package to ignore the error this column pulls in null values instead of real values. If it's not set to ignore the error this is the error message. The data type is INT. It's failing in the ADO NET Source task. Any ideas?
[ADO NET Source [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "ADO NET Source" (1)" failed because error code 0x80131937 occurred, and the error row disposition on "output column "XYZ" (749)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.