script task

Question

if I have a script task in a dataflow task as a datasource,  and it produces 5 rows for example.

I have two third party components to insert records to crm entities. ie. ent_hrd and ent_body

The rows contain field1, field2, field3 field4 and field5

I can map the script output field1 to ent_hrd and the other fields to ent_body. the problem im trying to figure out is how (if possible) to just pass the 1st record to ent_hrd but all five rows to ent_body

I know there is multicast which will feed both components, but how to limit one branch to just one record

in this sceniro I would want to end up with 1 record in ent_hrd and five records in ent_body

  

---

Dont ask me .. i dont know

Answer 1

Did you know that a Script Task can have multiple outputs? You can have a Header output and a Body output. In the script code you determine what gets sent out to what outputs. As long as there are not referential constraints between Header and Body tables you should be OK.

Try adding an output in the Script task and define the output fields that will be sent to it.

---

Todd C - MSCTS SQL Server 2005, MCITP BI Dev 2008 Please mark posts as answered where appropriate.