0
votes

I found this link that describes how to move a file after it has been imported using SSIS:

How do I move files to an archive folder after the files have been processed?

I would like to set up some error handling such that a file that fails to 100% successfully import gets moved into a different folder for manual review.

Can anyone help with this?

1

1 Answers

0
votes

Follow the same steps as in the question/answer you referenced, but change the destination if the import wasn't 100% successful.