Forum Discussion

JānisB's avatar
JānisB
Frequent Visitor
1 year ago
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...
Pipeline
  • JānisB's avatar
    JānisB
    1 year ago

    The problem is using temporary tables for the procedure. This problem is not solved.

     

    The solution is using table variables instead of temporary tables.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Rename your stored procedure to something less fancy, like 'AAADB-N-P'

JānisB's avatar
JānisB
Frequent Visitor
1 year ago

'AAADB_N_P' is not the name of a procedure.

I guess that #AAADB_N_P is the name of a temporary table for the procedure.

Procedure: [PBI].[sp_Rergher_HI_AZIDV_OPK_Ipaasg]

Procedure is made by a third party

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    Try running this with a SP in the default schema.

    • JānisB's avatar
      JānisB
      Frequent Visitor
      1 year ago

      Using [dbo].[sp_Rergher_HI_AZIDV_OPK_Ipaasg] the same error.

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        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.