question

DavidStein avatar image
DavidStein 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?
ssisvariable
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

billinkc avatar image
billinkc answered
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
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sabotta avatar image
sabotta answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DavidStein avatar image
DavidStein answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.