I am deriving a result set in a parent package and I have to pass the same to the Child Package. I found out that we cannot do this using Parent Package Variable configuration option. I found out a code using Script Task to pass this variable from Parent to Child Package. However, I am getting an error while using this approach.
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.".
Can someone let me know the reason why I am getting this error message. I use this variable in FEL container to access records. Is there any other better way to pass an object variable to child package.