Referencing the SSIS package in a server name with a "\"

  • HI,

    I have a package deployed to server sql123\T456(2008 R2). Now, I am trying to run the package from the server, I see that variable with the server name is having sql123\\T456 at the run time. Just wondering this is something to do with \???

    Any help will be appreciated..

    Thanks,

    VG

  • Yes. In the SSIS expression language, the \ is an escape character. Thus, if you want to have \ in your text, you need to escape it with itself, resulting in \\

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply