Menu
I'm a newbie in SSIS... I'm exporting data from a DBSource and outputing any errors to a Flat File. Now, when I connect the red arrow to the Flat Destination I'm receiving a warning from the DB Source "No rows will be sent to error output(s). Configure error or truncation dispositions to redirect rows to the error output(s), or delete data flow transformations or destinations that are attached to the error output(s)."
Does anyone know what it means? How can I get rid of that?
306
Drag a Flat File Destination onto the Data Flow and connect the red error path output from the OLE DB Destination onto the Flat File Destination. When the Configure Error Output window pops up, change the Error handling dropdown to Redirect Row and click OK to save your changes.
SSIS error outputs are a secondary path through which the data flow can send rows that do not conform to data type, length, or transformation standards defined by the ETL developer.
Error Output provides three SSIS Error Handling options: Fail Component: If there is an error, then the transformation, source, destinations, etc., will fail. Ignore Failure: It will ignore the row's failures. Redirect Rows: It returns the successful rows to the specified destination and failed rows to failed output.
By default, SSIS will "Fail component" on an error or truncation issue. You must tell SSIS that you do not want to fail the package, but you want to "Redirect Row" which will allow the flow to continue down the red arrow.
This should remove the warning message you are currently getting
57
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
