Post reply

Loop Through Tables as an Input to SP

  • June 10, 2009 at 10:50 am

    #132866

    Hi,

    I'm new with SSIS and I need to loop through a table and use it as an input to my stored procedure.

    Example:

    Table A

    col1 col2 col3

    val1 val2 Active

    val4 val5 Inactive

    where col3 = 'Active' (maybe a view will serve this condition)

    Stored Procedure

    SP_xyz(col1,col2,col3)

    A step-by-step example will surely be a great help.

    Thanks,

    Christopher

  • June 10, 2009 at 10:53 am

    #1007559

    Please don't cross post.

    Continue this thread here: http://www.sqlservercentral.com/Forums/Topic732456-147-1.aspx

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • June 10, 2009 at 10:57 am

    #1007560

    Sorry. I thought I can move it to SSIS topic.

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

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