SSIS - Source Error Output (No rows will be sent to error output(s)....)

Question

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?

Arturo

Answer 1

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.

• Edit your Source
• Go to the Error Output tab
• Set the relevant columns you want to trigger an error row redirect to Redirect Output as below.

This should remove the warning message you are currently getting

Sansbury

Answer 2

I had chosen the redirected rows in the source and still the warning remained. The mapping was good. Refreshing the metadata did not make it work.

I then removed the error path and the error table and put the two back in the data flow task. Then the warning was not shown anymore. It still did not redirect erroneous rows to the error table, but that must be another problem, see my remark at How to increase MaximumErrorCount in SQL Server 2008 Jobs or Packages? that setting the MaximumErrorCount to a high number does not lead to any error output.

Crossruff

Answer 3

Troubleshooting SSIS -Right click and show advanced editor on ODBC source>Input and Output Properties >ODBC source output >confirm the data type and length of internal & external columns(pay attention any columns that underwent any conversion earlier ) -Add derived column in my case I was converting string to datatimeoffset 7 And my entry looked like this -Open OLEDB destination editor > Mappings> select the derived column from the drop down menu and map to the desired destination.

Radferd