Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Passing Object Type Variable to Child Package Expand / Collapse
Author
Message
Posted Wednesday, January 09, 2013 12:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 10, 2014 3:09 AM
Points: 121, Visits: 1,386
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 7,070, Visits: 12,523
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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1406473
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse