This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 71%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
i schedule a job to run daily, normally, it run smooth without error, but sometime it will failed in copying file task in SSIS. actually, my task is moving the file from source to destination. however, I got SSIS error regarding "can't create a file which already exists". why?
I attached my SSIS screen capture.
SSIS error is as below:
File System Task Description: An error occurred with the following error message: "Cannot create a file when that file already exists. ".
anyone know how to fix it? is that i need to set "destination overwritten" to "Yes"?
Hi @nononame2021 ，
Cannot create a file when that file already exists.
From the error message, to fix it, you may set "destination overwritten" to "True".
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
hi, actually, i just move the file to destination, why it will fail.
after i check the file and the destination, they are all exists. why it will has failure. why it can't move file when setting overwritten destination to "Fales".
Hi @nononame2021 ，
Please make sure that the files do not exist before you run the package. The error message indicates that there is already file exists.
but the fail job task the regarding to move file to destination, but if i set the overwritten destination to fales, if the destination has this file, it will fail or it will not overwritten the file in destination but the task still success? so i am not sure if the issue is related to setting about "Overwritten destination". so i ask here.
If you set the overwritten destination to false and the destination has this file, the task will fail and thrown the error 'Cannot create a file when that file already exists.'
i see, i will try and reply you later. thanks.
but i found that no existing files in the destination, why it will causes this error?
Hi @nononame2021 ，
I could not re-produce the issue, and if you set the overwritten destination to true, will the error occur?
It looks like you are using a File System Task in SSIS to copy a file from one location to another, and you are getting an error saying that the file already exists at the destination.
One possible solution to this problem is to set the "OverwriteDestination" property of the File System Task to "True". This will cause the task to overwrite the file at the destination if it already exists.
This should cause the File System Task to overwrite the destination file if it already exists, and should resolve the "Cannot create a file when that file already exists" error.
If you do not want to overwrite the destination file, you can set the "OverwriteDestination" property to "False" and handle the error in a different way. For example, you could add a script task that checks for the existence of the file at the destination and handles the error appropriately.