I am a complete newbie to the world of SSIS so please bear with me if this seems a stupid question.
I am testing something as part of some self-learning and have a script that extracts data from a database table, pushes it out to a text file and then reads it back into another table in the database together with a value looked up from elsewhere. It all works fine.
So I've deliberately corrupted the initial output so that there is text instead of a monetary value, the idea being I thought I could redirect the error to a flat file (all part of my learning).
Except the package does the first bit ok (i.e writes out to a text file) but falls over when reading it back in, even though I've set it up to "redirect errors". The error is "unable to convert nvarchar to int".
Is SSIS not able to redirect these kinds of errors? Or does my learning have a long way to go?
Many thanks for any help.