Hi SQL server experts,
I tried to import a text file which has a row that has a column of value
222945700
This value is imported into an INT column without problem when I manually
did the import from management studio. But when I ran an agent job to import
the file, it failed. It complained about the overflow. I had made a package
for the import and the agent job calls the package.

This is the message from job history.
Description: There was an error with input column "Column 9" (87) on input
"Destination Input" (63). The column status returned was: "Conversion failed
because the data value overflowed the specified type.". End Error Error:
2008-10-17 20:57:01.57 Code: 0xC0209029 Source: Data Flow Task
Destination ... The package execution fa... The step failed.


Please help.

Pingx