File System Task Error in SSIS
Hi All, I am trying to move some .txt files with in same location different folder. Destination Filename=C:\Error Files\Specific Client Source Filename=C:\Error Files I used for each container in that I took file system task. In file system task Destination variable= Destination Filename, sourcevariable= Source Filename, operation=move, issourcepathvarible=true, overwriterdestination=true In for each container variable mapping= Source Filename, source file path and name and extension *.*. But I am getting below error [File System Task] Error: An error occurred with the following error message: "Could not find file 'C:\desc.txt'.". [File System Task] Information: File or directory "C:\ErrorFiles\Specific Client\desc.txt" was deleted. Please help me in this issue Thanks CMK..
November 15th, 2010 6:29pm

What operations are you doing in the ForEach loop container (other than moving the files to the destination)? If you are doing data loads, are the files being loaded successfully? I am trying to move some .txt files with in same location different folder. Destination Filename=C:\Error Files\Specific Client [File System Task] Error: An error occurred with the following error message: "Could not find file 'C:\desc.txt'.". [File System Task] Information: File or directory "C:\ErrorFiles\Specific Client\desc.txt" was deleted. In your post above, you've mentioned that your destination filename is "C:\Error Files\Specific Client"; however, in the error, it says "C:\ErrorFiles\Specific Client\desc.txt". Should there be a space between "Error" and "Files" or not? Could you please check if that is causing this issue? If the folder names are correct, did you check if the file actually exists in that location or has it been moved/deleted which is why the package is throwing the error?Shalin P. Kapadia
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 9:00pm

Depending on the action you want to to in the File Task (move, copy), the path has to include or exclude the filename. Please check this.
November 16th, 2010 3:36am

Thanks for your response i am trying to move the files [File System Task] Information: File or directory "D:\Applications\MB_COGNOS_FEEDS\Cognos_Net\ErrorFiles\ErrorFiles_Q1\09_18_2009\08_18_2009" was deleted. i am getting this error..forget about paths..those part every thing fine. Thanks CMK..
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 10:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics