• sathiyan00 (9/3/2012)


    Hi all,

    I'm new to sql server,so please help me to know about this.

    1) whether the ssis package will process 1 row at a time or whole rows.

    (i.e) it will take one record and process all the transformation then next or it will take all rows and process in each transformation.

    Both ways are possible 1 row at a time i.e. Synchronous Transformation and all rows i.e. Asynchronous.

    Please have a look on below URL

    http://msdn.microsoft.com/en-us/library/ms136114.aspx

    2) how to assign a value to a variable at run time after each row processed.

    You can have user defined variable and assign them programatically at later stage.

    For more information please see below URL.

    http://msdn.microsoft.com/en-us/library/ms141085.aspx

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂