Home Forums Data Warehousing Integration Services get data from a stored procedure RE: get data from a stored procedure

  • February 10, 2016 at 7:02 pm

    #1857909

    antonela (2/10/2016)

    Thank you, this functions properly.

    I found the solution at this link too:

    http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspx

    But is it some way to test how many records return the stored procedure?I need to transfer data only if the stored procedure return more than 1 record.

    I am not sure I understand what you mean. If the stored procedure returns 0 rows then by definition you won't be transferring any rows via the Data Flow.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato