[File System Task] Error: An error occurred with the following error message: "Source and destination path must have identical roots. Move will not work across volumes." So the workaround I suggested to move a folder from one drive to another drive using File System Task is as follows: Drag-drop two File System Task on the Control Flow, one for copying the folder from one drive to another drive because using File system Task by setting the option Operation = Copy Directory we can copy a folder across different drives, and the second one for deleting the folder by setting the option Operation = Delete Directory after copying it to destination drive, hence a folder is moved from one drive to another drive. Let us consider an example: I have folder named "Anil" in the path C:\Source (source drive) and the destination path is D:\Destination (destination drive) Copy Directory - File System Task: (To copy the folder "Anil" from C:\Source to D:\Destination ) DeleteDirectory - File System Task : (To delete the folder "Anil" from C:\Source )
Connection Managers: [ Copy Directory (File System Task) - Left top image is Destination Connection Manager, Left bottom image is Source Connection Manager and Right side image is Connection manager for DeleteDirectory (File System Task) ] Using SSIS - Script task with VB / C# code , we can move a folder from one drive to another drive , but to move a folder from one drive to another drive using File System Task, I guess the above suggestion is the only work around .
Ed Price - MSFT edited Revision 2. Comment: Title and tags
Naomi N edited Revision 1. Comment: Minor change