question

goussarova avatar image
goussarova asked

procedure executes in sql studio, breaks in bcp

Hi,

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.

Thank you!

sqlbcpprocedurestored procedure
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.