Post reply

Execute stored procedure from Transform Data Task

  • March 3, 2003 at 2:59 am

    #106152

    I need to execute a stored procedure in Data Pump Task.

    (Transform Data Task Properties --> SQL Query)

    If the stored procedure has not any parameters, I've not problem.

    But, if the stored procedure, has any parameters I don't find the correct

    sintax....I do not succeed!!

    (The stored procedure return a result set that I use for load a text file.)

    Help me, please

    You can write a short code for example??

    Many many, Thanks!!

    Flavio

  • March 3, 2003 at 3:28 pm

    #450169

    Best to put a ExecuteSQL task before the datapump to load the data into a staging table, then use the datapump to select from that table.

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • March 3, 2003 at 3:33 pm

    #450171

    Another work around, If you specify the source as an SQL statement and define the transformations. Save the package. Then you can modify the source SQL statment to be a parameter driven procedure as long as the resultset from the procedure exactly matches what was there previously.

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply