I need to execute procedure abc using bcp or ssis under sql credentials xyz.
When I create a connection in sql studio for xyz, "exec abc" runs with no problems.
When I run bcp for the same "exec abc", same credentials, it breaks with 'Invalid object name #prev_c'.
This object is apparently a part of the abc.
I get the same error when I try to build ssis package.
I have no control over procedure abc, but I can add permissions to xyz, though I have no clue what additional permissions I need to give.
So, my question boils down to - why a procedure can run in sql management studio, but breaks in bcp under same sql credentials, and is it fixable with additional permissions?
Any help will be much appreciated.