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.