Hi
I'm not sure if this is a request, or bug or just an annoyance. Anyway, when you lookup the available procedures in an SQL task, they are listed without schema prefix. So if you have a procedure in another schema than dbo, it will fail and say it cannot find the procedure. You then have to add the prefix to the procedure, eg like this: schema.p_procedureName. This works, but when you add a schema prefix, the parameters disappear from the list, so you have to manually add the parameters again. I believe this was not the case in previous releases.
Regards
Thomas
Edited by moderator
2014-07-21T11:59:30Z
|
Reason: Not specified
thomas attached the following image(s):