Variable adds an extra "\" to the folder path

  • The error was due to something else. However, when you view a variable the fact remains that it replicates the "\" , although that does not come in the way of proper execution.

    All works well now. 🙂

  • Awesome 🙂

  • namrata.dhanawade-1143388 (1/4/2011)


    The error was due to something else. However, when you view a variable the fact remains that it replicates the "\" , although that does not come in the way of proper execution.

    All works well now. 🙂

    That's because \ is a special character in SSIS. Therefore, when you want to place a \ in a string, you need to escape it with another \.

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

Viewing 3 posts - 1 through 4 (of 4 total)

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