none
SSIS Project Parameter with a forward slash ( / ) RRS feed

  • Question

  • The project parameter is remotePath.

    The default value for remotePath is path/to/file

    When executing the package in Visual Studio 2010 everything works fine.

    When I create a SQL Server Agent Job for the package, I get an error message when the job executes.

    The project parameter is remotePath.

    The default value for remotePath is path/to/file

    When executing the package in Visual Studio 2010 everything works fine.

    The challenge is the forward slash is interpreted as a new parameter rather than the value for the current parameter.

    Any thoughts would be appreciated.


    Thank you, Bill

    Monday, September 16, 2013 2:23 PM

Answers

  • Thank you for the replies.

    I tried using // but that did not work either.

    Ultimately, I used z9z to represent the /.

    In the package, I conver z9z to /.

    It is really clunky but I could not figure out a better way as expressions are not supported.


    Thank you, Bill

    • Marked as answer by jessiedog Monday, September 16, 2013 9:06 PM
    Monday, September 16, 2013 9:06 PM

All replies

  • If I understood you correctly you have a permission issue with the SSIS job. I therefore believe the issue may be fixed by running the job with a proxy: http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

    Arthur My Blog

    Monday, September 16, 2013 2:44 PM
    Moderator
  • Hi Bill,

    Like Arthur suggested , it may be because of permission issues or try to escape the character "/"

    like "path//to//file"


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    Monday, September 16, 2013 5:51 PM
    Moderator
  • Thank you for the replies.

    I tried using // but that did not work either.

    Ultimately, I used z9z to represent the /.

    In the package, I conver z9z to /.

    It is really clunky but I could not figure out a better way as expressions are not supported.


    Thank you, Bill

    • Marked as answer by jessiedog Monday, September 16, 2013 9:06 PM
    Monday, September 16, 2013 9:06 PM