question

balanarasimhac-1495 avatar image
0 Votes"
balanarasimhac-1495 asked ZoeHui-MSFT commented

Load, Archive files and move error files to another folder in SSIS

Hi Team,

How to archive file after loading into table and move files to different folder if any file having errors

Thanks in advance

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @balanarasimhac-1495,

You may follow move-files-to-an-archive-folder-after-the-files-have-been-processed steps to move the files to other folder.

And then add another link from the data flow task to a new file system task, change the link to "Failure" and create a new folder, adding one additional variable for the failures folder name.

Here are also some links you may take a reference.

https://stackoverflow.com/questions/57308925/ssis-foreach-loop-move-each-file-to-folder-done-or-error-based-on-any-errors-du
https://www.sentryone.com/blog/how-to-loop-through-files-in-a-specified-folder-load-one-by-one-and-move-to-archive-folder-using-ssis
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7c29c712-19e0-4859-adea-8058161d6390/excel-file-import-error-handling-move-files-to-folder-on-task-failure?forum=sqlintegrationservices

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

May I know how's the issue going on now? If you have any updates, don't forget to tell us.

0 Votes 0 ·