Hey all,
I'm hoping someone has dealt with this before.
I have a SQL Job that uses a command line to pass variables to my SSIS package. One of these variables is @myServerName. Everything works great when the values are as follows "Server1", "Server2".
But now we have a named instance and when I try to pass "Server3\Server1" the job is failing with this error "Incorrect syntax near '\'.". I know that this is causing the error becuase if I change that back to "Server1" it will run just fine.
How can I pass a named instance to my SSIS package through the job?
I have tried "[Server3\Server1]" and even tried "Server3\\Server1" with no luck.
Thanks in advance for your time.