Problems passing Result Set to ForEach Loop
Hi
Probably joust a newbee question.... and iknow that this have been discussed here before, but i have not have had any success getting it working, from the described solutions
I am trying the following:
Execute SQL task:
That gets a list of BigInt results
Result Set: Name = 0 Variable: Object
ForEach Loop:
Collection: Foreach ADO Enumerator
ADO object Source Variable: The Object from The Execute SQLTask
Rows in the first table
VAriable Mapping: Index= 0 Variable: String
As described in some of the blogs i have found, but i still get the following errors:
Error: 0xC001F009 at KundeVareStatistik: The type of the value being assigned to variable "User::Current_IDCustInvoiceTrans" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Error: 0xC001C012 at Foreach Loop Container: ForEach Variable Mapping number 1 to variable "User::Current_IDCustInvoiceTrans" cannot be applied.
So i hope thatsomeone can help me
Thanks on advance.
/Graves
June 9th, 2008 10:45am
at design-time, the data type of User::Current_IDCustInvoiceTrans should be object.
hth
Free Windows Admin Tool Kit Click here and download it now
June 9th, 2008 11:26am
Thanks Duane,
I got the same problem and i resolved it using Object variable.Masti
November 29th, 2010 2:12pm