Foreach ADO Enumerator? RRS feed

  • Question

  • my setting in foreach component like below shown

    Enumerator: Foreach ADO Enumerator

    ADO Object source variable: user::strsql

              strsql like "select distinct name from table"

    Enumeration mode: Rows in the first table

    my goal: transform data according to the distinct every name

    however execute error

    prompt: Variable "User::strsql" does not contain a valid data object

    pls help,thanks in advance


    Monday, December 18, 2006 11:09 AM


  • The foreach ADO Enum, needs and OBJECT type.

    You need to create a Execute SQL Task with the SQL you want, then asign the return to the object variable.  Then use the object as the ADO Object.

    See this example: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx

    Monday, December 18, 2006 3:24 PM