SSIS File system task Rename file deletes source file

Michael Kraemer 0 Reputation points
2023-12-29T17:10:40.6233333+00:00

I'm using a file system task to copy a file from one location to another renaming the file in the process. It seems to be deleting the source file How do I prevent this?

Thanks

User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
SQL Server Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,491 Reputation points
    2024-01-02T06:13:42.31+00:00

    Hi @Michael Kraemer,

    How do you set the destination path?

    I tried to select Create File option from the Usage Type.

    User's image

    Click on the Browse button to select the Destination Folder from the file system.

    I User's image

    In this way, it will rename the file without deleting the source file.

    Regards,

    Zoe Hui


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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.