Excel file loading in SSIS

67 views Asked by At

I want to move the failed excel files to error folder and loaded excel files to archive folder in SSIS The excel file having multiple sheets and the folder contains multiple excel files.

1

There are 1 answers

0
Chris Mack On

You can use a File System Task for this:

https://learn.microsoft.com/en-us/sql/integration-services/control-flow/file-system-task

You would place this in your loop, and I'd set a success/failure (Boolean) variable to control the destination directory.