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