duplicated path
hello all, I got this error message: [File System Task] Error: An error occurred with the following error message: "Could not find file '\\ipsapps43\d$\Program Files\IPSUtilities\Tx\Decrypted\ipsapps43\d$\Program Files\IPSUtilities\Tx\Decrypted\Even-More-Values.txt'.". I don't know why I got the duplicated path. here's my variables: varSourceFolder: value: \\ipsapps43\d$\Program Files\IPSUtilities\Tx\Decrypted evaluateasexpression: True expression: @[User::varSourceFolder]+@[User::FileName] FileName: evaluateexpression: False expression: @[User::FileName] This File System Task is inside a ForEach Loop container.
November 20th, 2012 11:40am

Hello mdpham, \\ipsapps43\d$\Program Files\IPSUtilities\Tx\Decrypted\ipsapps43\d$\Program Files\IPSUtilities\Tx\Decrypted\Even-More-Values.txt' means you used a fully qualified name in the ForEach Loop whereas you need the folder only Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 20th, 2012 11:45am

Thanks ArthurZ, I got rid of the duplicated path, however, I ran into another error: [File System Task] Error: An error occurred with the following error message: "Could not find file '\\ipsapps43\d$\Program Files\IPSUtilities\Tx\DecryptedEven-More-Values.txt'.". It looked like it did not put a \ after the Decrypted folder. Do you know why? Thanks again.
November 20th, 2012 12:09pm

Thing is the path captured by the ForLoop would not include the ending backslash. Thus, you need to revise your SSIS Expression, perhaps you need to prefix it with the backslash \.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2012 2:20pm

if you use expression, try to use two \\ instead of one \ you are welcome
November 21st, 2012 2:26pm

Thing is the path captured by the ForLoop would not include the ending backslash. Thus, you need to revise your SSIS Expression, perhaps you need to prefix it with the backslash \.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2012 10:16pm

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

Other recent topics Other recent topics