I have stuck on a this little issue...i cant seem to import a date field YYYYMMDD from flat file Soucre to a SQL DB. I am using SSIS 2008.
I get the below error message:
SIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "dob" (1881)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "dob" (1881)" 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.