Passing Object Type Variable to Child Package

• MuraliKrishnan1980

  SSCrazy

  Points: 2497

  More actions

  January 9, 2013 at 12:07 am

  #272541

  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.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  January 13, 2013 at 9:25 am

  #1576682

  I am assuming this was your post on MSDN and it is now resolved:

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/d00bb280-77bd-487c-8785-658beb08e296

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato