CODEWITHSUNDEEP
sqlssis
Funky
Funky

Reputation: 11

SSIS Conditional Split Error Output not writing any data to table

I have created this simple SSIS package: img1 This is my conditional split: img2
This is the Configure Error Output: img3 I am getting this error when running:

[ErrorTable [52]] Warning: Rows sent to the error output(s) will be lost. Add new data flow transformations or destinations to receive error rows, or reconfigure the component to stop redirecting rows to the error output(s).

Before I got this error it was creating the error table but did not write any rows so I changed it to redirect row and now have this error. I'd be grateful for any help.

Upvotes: 1

Views: 742

Answers (1)

Gene Hayes
Gene Hayes

Reputation: 11

I just ran into the same issue and think I found the answer.

The output from your conditional split should not be the red "Error" path, but another output path (blue) to the "Error" file.

I kept expecting the red path to output the data from the conditional split, but it didn't because there actually weren't any errors.

I'm learning here, but I'm guessing the red "error" path is for actual data issues and not the conditional split functions.

Hope that helps! I

Upvotes: 1

Related Questions