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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics