data flow task - ole db source to records destination and to another table
hello, i have oledb source (using complex query) which insert the records in another table. i want two path, one to insert record in another table and another to records destination becasue records destination i want to use for foreach loop for some other purpose. so question, is it possible to have two path? if not then is there way i make add two data flow task and use the same source destination in both of them (this way if i make a change in my source destination query it will reflect at both places). thanks, pmark it as answer if it answered your question :)
October 31st, 2010 9:58pm

Yes... you need the Multicast transformation to create two flows of data to send to different destinations. Cheers, JamesJames Beresford @ www.bimonkey.com SSIS / MSBI Consultant in Sydney, Australia SSIS ETL Execution Control and Management Framework @ SSIS ETL Framework on Codeplex
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2010 10:04pm

One word: Multi-Cast transform on the data flow! Self-explanatory.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
October 31st, 2010 10:05pm

ok, sounds like there is possibility. i'm new to ssis so not sure how to do multicast, is it possible if you guys could provide little more detail on it? thanks, pmark it as answer if it answered your question :)
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2010 10:09pm

ok, sounds like there is possibility. i'm new to ssis so not sure how to do multicast, is it possible if you guys could provide little more detail on it? Inside Data flow task, take an OLEDB Source and use your complex query as data source (data access mode as SQL Command). Then take a Multicast component and drag the green op of OLEDB Source as input for Multicast component. Now add the destinaiton components and drag the op of multicast to each destination.Nitesh Rai- Please mark the post as answered if it answers your question
October 31st, 2010 10:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics