Skip to Content
0

Executing stored procedure using sql transform in bods

Mar 27, 2017 at 02:58 PM

75

avatar image

I have to execute a procedure and make it as my source.. I did it through sql transforma by calling the sp in it.. For one particular procedure the schema doesn't map saying it uses temp tables.. The proc is in sql server and i have used temp tables in it.. Kindly hel..

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Magesh Subramanian Mar 28, 2017 at 02:56 PM
0

Does the stored procedure restuns a table?

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Mar 28, 2017 at 03:52 PM
0

Hi Vivek,

Can you please explain why do you want to use temporary tables in Stored Procedure code. Data services will not work with temporary tables as they exists only for a particular session.

Every Dataflow and sql() call is a separate connection to the database. The TEMPORARY table(#table_name) is cleared out when a session is disconnected.

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded