Exec SQL step retrieves field from table. Output is full result set, goes to
global variable of object type.

ForEach loop set for ForEach ADO Enumerator. ADO object source is the
global object variable from above, "Rows in first table" selected. Variable
at index 0 (the only field in the rowset) is mapped to a string-type variable.

I keep getting an error message saying the type of value I'm currently
assigning differs from the current variable type, but everything I've read in
the books and on the web says this should work.

Once again, answering my own question, but I found the solution.

The field I was extracting was numeric. I had to cast it as a varchar in
the select statement, then use a STRING variable for the mapping.

"Mike Coffey" wrote: