How to edit the expression

Jefferson-2765 586 Reputation points
2023-12-27T09:41:39.88+00:00

I created a variable Which i used an expression.

"\data\local\test"

And the error occurred

Expression cannot be evaluated. Additional information:

The string literal "\dataVocal\test"" contains an illegal escape sequence of "\d". The escape sequence

is not supported in string literals in the expression evaluator. If a backslash is needed in the string, use a double backslash,"".

Attempt to parse the expression ""\dataVocal\test"" failed and returned error code 0xC00470B8.The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.

(Microsoft.DataTransformationServices.Controls)

SQL Server Integration Services
0 comments No comments
{count} votes

Answer accepted by question author
  1. ZoeHui-MSFT 41,536 Reputation points
    2023-12-27T09:50:32.0333333+00:00

    Hi @Jefferson,

    If a backslash is needed in the string, use a double backslash.

    You may need to double the slashes in your expression.

    "\\data\\local\\test"
    

    User's image

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.