Hi
I am using yukon April CTP.
I have a excel source. Every row from excel has to go to one master table
and one detail table.

I want to know how to insert a row to master table, get the scope_identity
and then insert to detail table using SSIS.

Note: Currently sending the row from excel sheet to a stored procedure
where I am managing to insert to master and detail table.

Thanks
Harini

Harini Srinivasan wrote:
I think your method sounds fine. Why Multicast into two paths for the
same data? You will require twice the memory as you have twice the data
flowing through the pipeline. Whilst SSIS is very cool, and you can do
ETL vs ELT as we normally do with DTS, it doesn't mean you should do
everything in SSIS.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com