How to Copy all the files from one directory to another, and if file already exists then skip

Question

I want to copy all files from one folder to another folder. But if that file already exists in the destination folder, it should be skipped.

I did that using Foreach loop with 'OverwriteDestination'="False" but failed to skip already present file.

How shall I accomplish the same?

Any help is appreciated. Thanks.

Answer 1

Hi @Anjali Shah ,

You may use Script task to check if the file exists.

And then use Foreach Loop Container and File system task to copy the files.

Here is a detailed example you may take a reference.

https://stackoverflow.com/questions/6598139/how-to-loop-only-through-files-that-dont-exist-in-destination-using-an-ssis-pac

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.