SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Pass SSIS Object to child SSIS package


Pass SSIS Object to child SSIS package

Author
Message
blasto_max
blasto_max
Old Hand
Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)

Group: General Forum Members
Points: 375 Visits: 480
I tried to pass a SSIS Object (actually a DataSet) to a child package. I got an error which tells me that I am not allowed to do that. Why can't I do it ? This never happens in a programming language. Are there any workarounds for this ?

Thanks.

EDIT -

Error - Property "Value" with type "Object" of variable "User::MY_DATA_SET"
can not be exported to the configuration file.
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8645 Visits: 7660
You were trying to pass an object variable with a dataset in it to the child package, or something else? Need a little more detail about exactly what you're trying to pass.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
blasto_max
blasto_max
Old Hand
Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)

Group: General Forum Members
Points: 375 Visits: 480
Evil Kraig F (12/18/2013)
You were trying to pass an object variable with a dataset in it to the child package, or something else? Need a little more detail about exactly what you're trying to pass.


Actually, it is an Object which is meant to hold a DataSet. I was trying to pass this variable via child package config. Does that make my question clear ?
Elliott Whitlow
Elliott Whitlow
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10180 Visits: 5314
I didn't think you could pass an object between, virtually everything else yes.. But not an object.

CEWII
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8645 Visits: 7660
blasto_max (12/18/2013)
Evil Kraig F (12/18/2013)
You were trying to pass an object variable with a dataset in it to the child package, or something else? Need a little more detail about exactly what you're trying to pass.


Actually, it is an Object which is meant to hold a DataSet. I was trying to pass this variable via child package config. Does that make my question clear ?



Yup, just wanted to make sure we were talking apples to apples.

Check out this article. System.Object doesn't want to work via configurations.
http://agilebi.com/jwelch/2009/10/03/passing-an-object-from-a-parent-package-to-a-child


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
blasto_max
blasto_max
Old Hand
Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)

Group: General Forum Members
Points: 375 Visits: 480
Evil Kraig F (12/18/2013)
blasto_max (12/18/2013)
Evil Kraig F (12/18/2013)
You were trying to pass an object variable with a dataset in it to the child package, or something else? Need a little more detail about exactly what you're trying to pass.


Actually, it is an Object which is meant to hold a DataSet. I was trying to pass this variable via child package config. Does that make my question clear ?



Yup, just wanted to make sure we were talking apples to apples.

Check out this article. System.Object doesn't want to work via configurations.
http://agilebi.com/jwelch/2009/10/03/passing-an-object-from-a-parent-package-to-a-child


Thank you very much. It works now ! But, this is so unintuitive. I wish it was more like programming.
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8645 Visits: 7660
blasto_max (12/18/2013)


Thank you very much. It works now ! But, this is so unintuitive. I wish it was more like programming.


My pleasure. I'm pretty sure the problem comes down to the unknown size of the variable involved and the child package doesn't receive anything ByRef, only ByValue. The object in question should be passed ByRef in my mind, but they don't. No idea why. I didn't see anything in my browse showing this was improved in 2012 or beyond, either.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87376 Visits: 41113
Nice trick. It's also another notch on a 2x4 list of reasons why I try to do everything in T-SQL. ;-)

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8645 Visits: 7660
Jeff Moden (12/18/2013)
Nice trick. It's also another notch on a 2x4 list of reasons why I try to do everything in T-SQL. ;-)


Yeah, yeah, my favorite Luddite. Tongue

Considering I avoid child packages in general like the plague, I don't run into this very often. I find them to offer little assistance, as you can rarely modularize a child package well enough for multiple inheritance of over 3 packages (my minimum for when I look to standardize code calls in just about everything). SSIS shouldn't be treated like standard coding where you're typically trying to pass information between multiple component functions off a MAIN() or whatever.

SSIS however is awesome for laying out processing methodology and calling sequential procedures with obvious and self-documenting logic pathing, however. There's plenty of other things it can do but I find a single package controlling a complete task to be very easy to read without having to dig through code to find the control pass points or dig through signficantly complex if trees. There's also places where it's faster than T-SQL (small lookup lists come to mind) if your transforming across servers.

And now I sound like a brochure. No more after midnight typing for me. Bedtime! Hehe


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
blasto_max
blasto_max
Old Hand
Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)Old Hand (375 reputation)

Group: General Forum Members
Points: 375 Visits: 480
Thanks for all the tips @Evil Kraig F. I made a child package which will accept a DataSet from a parent package and convert it into a CSV file. Since you mentioned that child packages are inconvenient and are to be avoided, I was wondering if you can see/foresee any problems in my approach ?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search