Hi Steve-

I configured the error redirect step in data conversion task instead of flat file source. No luck.

thanks!

I will give it a try. what if I did not have the data conversion task but wanted to redirect the error rows from extract to flat file destination?

error redirect is on the flat file source task

Hi David-

your approach worked. There was a structure mismatch between the source and destination columns.

thanks!

Hi David-

Thanks for your detailed inputs but no luck, same error.

[Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Column 20" returned status value 2 and...

Hi- I did,

1. Added a derived column and casted the type to DT_I4. Expression used is (DT_I4) [Column 20]. In this case the data type of column 20 in Flat...

Hi John-

I did notice that the value in extract is like 00000140, 00001236 etc fixed length. The problem is data in extract is string but I have to configure the...

thanks. I'm still thinking the way i used to with DTS:)