October 31, 2008 at 10:17 am
Is it possible to use a DataReader Destination inside a child Integration Services Package and read the in-memory result inside a parent package with DataReader Source?
As i see, there is no way to set a package as a source inside a connection manager, right? (I'm not going to write my own Provider, but this could be a way!?)
I'll go the way by placing the result of my child package to an flat-file or database table to read the result in my parent package if no one can light me a way through the DataReader.
edit: used for SQL Server 2005
October 31, 2008 at 6:15 pm
I am going to dig around a little further, but I am thinking you might just want to dump this to a flat file or raw file. I believe I recently read a blog posting about reusing an datareader destination, so I will see what I can dig up tomorrow. I did find this reference from Jamie in the MSDN forums here - MSDN Forum Posting.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 1, 2008 at 6:47 am
Now that I read your posting again you want to pass the result back to the parent...outputting the result to flat file, raw, or xml would be your best option from what I can see. If you wanted to use it to pass to another data flow or child package then you have some options using the datareader destination or a package variable, but to get it back to the parent package I believe you are going to have to use one of the destinations listed above if you don't want to write the data back to a database to be consumed.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 4, 2008 at 8:50 am
Thanks a lot for your help "Grasshopper".
I found a possible solution in "CozyRoc SSIS Data Flow Components", maybe this components can help me build my needed workflow.
November 4, 2008 at 3:30 pm
No problem. If you were doing this within in existing package you could load the reader and populate a variable with the results (object type variable). Then in the package you could take the contents of that and use the foreach loop and access the contents of the ado object. If you check out Jamie Thompson's blog he has a few examples of this (one with a SSAS processing task and another where he shreds a recordset).
http://blogs.conchango.com/jamiethomson
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply