I have several DTS packages that I am re-creating in SSIS. The packages run perfectly under SQL 2000, but after creating them in SSIS and verifying the that data type and column width are correct, I'm getting a data conversion failed error. The exact error reads:
1) [Flat File Source ] Error: Data conversion failed. The data conversion for column "Column 31" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
2) [Flat File Source ] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "Column 31" (152)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "Column 31" (152)" 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.
3) [Flat File Source ] Error: An error occurred while processing file "\\AS013278S\efile_ftp\CA571EDOWN" on data row 1.
I looked at all the properties and can't see what's causing this problem. The source file resides on a remote server, and is in a "file" format. Any help with this matter will be greatly appreciated.