Home Forums SQL Server 2005 Business Intelligence Converting Stored Procedures to SSIS packages RE: Converting Stored Procedures to SSIS packages

  • October 17, 2012 at 2:50 am

    #1549914

    deepa lekshmi (10/16/2012)

    There are SPs that call another SP many times with different parameters(The parameters are hardcoded in the SP).

    There may be some scope for improvement here. That's logically equivalent to a WHILE loop.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]