Extract Load Transform SQL Server

File System Task error could not find a part of the path

If you are trying to move a file using the SSIS filesystem task and you receive this error: “Could not find a part of the path…” Googling for answers may result in the hint to use the rename action instead. If that indeed works, you are most likely ignoring the original problem which may be that your destination path contains the filename. To correctly setup the File System Task for file move actions the source and destination have to be configured as follows:

  • Source: Folderpath + filename
    • D:\FolderSource\File.csv
  • Destination: Folderpath
    • D:\FolderTarget