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.
Using [dbo].[sp_Rergher_HI_AZIDV_OPK_Ipaasg] the same error.
Hi JānisB ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.