Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Passing Object Type Variable to Child Package Expand / Collapse
Posted Wednesday, January 9, 2013 12:07 AM


Group: General Forum Members
Last Login: Thursday, March 3, 2016 11:43 AM
Points: 121, Visits: 1,409
Hi Friends,

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.

Post #1404565
Posted Sunday, January 13, 2013 9:25 AM



Group: General Forum Members
Last Login: Yesterday @ 3:25 AM
Points: 7,933, Visits: 14,355
I am assuming this was your post on MSDN and it is now resolved:

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1406473
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse