Executing stored procedure using sql transform in bods

[Former Member]

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..

[former_member198401]

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

[mageshwaran_subramanian]

Does the stored procedure restuns a table?