asked
Problem when using Variable Destination for File System Task.
Let me preface this by saying that this site will not allow me to display a double backslash so I'm substituting "XX" for it. I'm trying to use a variable destination for a file system task. I am having problems with the Double \ escape on the variable so I've narrowed it down to it's most basic element. The variable(s) are scoped at the package level. The DestinationPath variable expression is: "C:XXDirectoryNameXX" This of course evaluations to: C:\DirectoryName\. However, when I use a watch window, the value shows as "C:XXDirectoryNameXX". I cannot enter the expression without the double \ escape without error. Any idea why this is happening?
Perhaps I'm missing something in my setup ![Variable definition][1] ![Data flow][2] [1]:
http://ask.sqlservercentral.com//upfiles/askssc.variable.png [2]:
http://ask.sqlservercentral.com//upfiles/askssc.dataflow.png
I configured the File System Task using this expression for the Destination property: "C:XXtempXXDestination". The expression evaluated successfully. I'm also using X to replace the backslash because the forum seems to require it.
I'm sorry, I figured it out guys. I had chosen the option to Move the file, not Rename the file and that was causing the actual error.
