SSIS File System Task Rename File Could not find a part of the path error

Question

I have created a SSIS package that uses a File System Task that moves and renames a file from one folder
to another in one step. The package runs fine and it works a great (it moved and renamed the file) when I use the local drive file paths (I'm using variables) for source (C:\temp\mysourcefile\abc.txt) and
destination (C:\temp\myarchivefile\abc20160606.txt) but when I use the network drive file paths (variables):
source(\\Geneva(machine)\hsteam(share)\it\projects\provider\mysourcefiles\abc.txt)
and destination(\\Geneva(machine)\hsteam(share)\it\projects\provider\myarchivefiles\), the
package runs successfully but it didn’t move and rename the file. And I also
see the following error in the log:Error: 0xC002F304 at Rename file, File System Task:
An error occurred with the following error message: "Could not find a part
of the path.".<o:p></o:p>

SSIS package "myTest.dtsx" finished:
Success.<o:p></o:p>

The program '[3952]
myTest.dtsx: DTS' has exited with code 0 (0x0).<o:p></o:p>

Answer 1

You might have to replace the single back slash with double backslashes in variable

like Var = '\\\\Machine\\hsteam\\it\\...

---

TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA

Answer 2

Hi JeannieC320,

 

As far as I know, providing the new file name in the destination path is necessary when renaming file with File System Task in SSIS.

 

According to the error message, I think you need to verify the path is correct and make sure you have permissions to access destination folder with current user.

 

By the way try to use IP address instead of machine name in the path.

 

Regards,

Seif