HELP needed with multicast
-
Hi,
I need some help to design a package. I am getting confused as to what to put into control flow, and what to put into data flow, and the interplay of thetwo.
I have a resultset which will return two type of records. I would like these records to be dealt with differently, each type being dealt with one by one in a for each container.
First I created an ExecuteSQL task to return the resultset. Then I couldn't find a way to pass this over to my multicast step within the dataflow task.
So then I put my query in a dataflow OLEDB SQLcommand. Problem now is that the multicast task doesn't seem to link up with that resultset either. When I go into the editor, there is nothing there. Additionally, how do I then pass the two resultsets back to the control flow, for their respective For each loop container task.
Sorry if this is obvious, but BOL has been of little use so far!
I REALLY need to get this done
, so any help will be REALLY appreciated. -
I have now found the recordset destination. And I think I need a conditional split, not a multicast?
-
Would it be simpler to do this in two stages - using two resultsets (one for each 'type' of records)?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Yes, that's exactly what you need. This article should help: http://www.sqlis.com/default.aspx?59
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson -
Thanks for the responses. I will break the task into simpler steps, as recommended.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply