I am using the red arrow for true failures but since my source is excel the driver posts a fatal error when the data doesn't convert and will not go into the fail constraint. It red x's at the data task unless I change from fail to redirect row. I am using error output to write the rows to a table. I am trying to use the rowcount in the dataflow that is counted going into the error output back in the control flow to branch on success and rowcount > 0 to a file task to move the file to an error directory. I am processing 100's of xlsm files.

I never would have expected that this is a difficult thing to do. I am beginning to loath excel. I have little control over the source files since they are generated by the user.

read file

read sheet1

write to table1 on error move file to error directory

on success read sheet2

write to table2 on error move file to error directory delete rows from table 1

on success move file to completed directory

loop until no more files... sigh