I've run into some trouble with a script library. From my testing, it appears like my Script Library is unable to read variables scoped at the server-level. Is this true?
In my script library, I'm doing this:
That variable is defined at the server-level (Tools->Server Options->General Options->Variables). When viewing the log, the connectionString variable is empty and I get a subsequent error message about an uninitialized connection string (the SqlConnection object confirming it's empty).
For testing, I set the variable at the job-level and the job completed successfully. When I deleted the variable and re-inherited it from the server, the job failed again.
Any truth to this?