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