Hi Team,
How to archive file after loading into table and move files to different folder if any file having errors
Thanks in advance
Hi Team,
How to archive file after loading into table and move files to different folder if any file having errors
Thanks in advance
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
May I know how's the issue going on now? If you have any updates, don't forget to tell us.
6 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh