SSIS DATA FLOW

  • 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.

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

    Thanks and Regards

    Sathiyan

  • 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
    🙂

  • hi rhythmk..

    thanks for ur reply...

    i want to join u in gtalk my id 'sathiyan.raul@gmail.com'

    Thanks and Regards

    Sathiyan.R

  • sathiyan00 (9/4/2012)


    hi rhythmk..

    thanks for ur reply...

    Thanks and Regards

    Sathiyan.R

    Will send you the invitation on the same.However I am not frequently using it.

    Also please avoid to put your personal detail(email id) on public forum as it may flood your mailbox unnecessarily with junk mails 🙂

    You can use private meassages for the same.

    --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
    🙂

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

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