Forum Discussion
Solved
Error retrieving data from a data source with stored procedure
Hi, Pipeline > Copy data activity > Source SQL Server > Use query = Stored procedure (on-premises connection) Procedure: [PBI].[sp_Rergher_HI_AZIDV_OPK_Ipaasg] (if it matters) Procedure is made b...
The problem is using temporary tables for the procedure. This problem is not solved.
The solution is using table variables instead of temporary tables.
The problem is using temporary tables for the procedure. This problem is not solved.
The solution is using table variables instead of temporary tables.