none
Array like facility in SSIS RRS feed

  • Question

  • I have  got a task in SSIS in which I have to create a variable of type OBJECT in the parent package and retrieve all the rows of a column of a table. And then I need to insert the required values to their respective variables in the child packages.

    Earlier I have used SINGLE ROW RESULT SET to store the result of the query and then with the help of Package Configurations I have assigned the value of parents variable to the respective child package variable. But this is laborious work as I have many such values to assign.

    How can I do this with FULL RESULT SET ?

    PLS HELP!!!

    • Moved by Naomi N Thursday, April 18, 2013 5:07 PM Better answer can be here
    Thursday, April 18, 2013 10:36 AM

Answers

  • Use For Each Loop container with "Foreach ADO Enumerator" and select the object variable where you have stored the Recordset. You can specify the columns -> variables in the 'Variable Mappings' tab.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    • Marked as answer by Eileen Zhao Thursday, April 25, 2013 5:58 AM
    Friday, April 19, 2013 2:48 AM

All replies