ssisssis-2012ssis-2008msbissis-2016

SSIS- ADODB Recordset Error

I am getting below error while running my ssis package.

Error: COM error object information is available. Source: "ADODB.Recordset" error code: 0x800A0BCD Description: "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.".

I am storing a value in an object variable using RecordSetDestination. And I am passing the object variable in 3 ForEachLoop containers and I am trying to run it parallel. If one of the container is passed then the rest of them getting failed.

enter image description here

Below is the same configuraiton in all 3 ForEachLoop's

enter image description here

enter image description here

Any property needs to change or object variable need to rest or we can't use the object variable for parallel exec in ForEach ADO Enumerator.

Need your input here... Thanks

Solution

  • The problem is the variable for the recordset. The first option would be you add three data flows like origins pointing each one to a different variable. The second is adding a multicast in your initial data flow, with three outputs, each one pointing to a different variable. Then you go to each Foreach Loop Container and set the respective variable in the Enumerator configurarion section.