In a data warehousing scenario, it's not rare to replicate data of a source table to multiple destination tables, sometimes it's even required to distribute data of a source table to two or more tables depending on some condition. For example splitting data based on location etc. So how we can achieve this with SSIS? SSIS provides several built-in transformation tasks to achieve these kinds of , for details click here.
It 's an amazing and awesome blog. Thanks for sharing
ReplyDeleteBest Msbi Online Training
Msbi Online Training in Hyderabad
Thank you for introducing this tool. keep it updated.
ReplyDeleteMsbi Online Training in Hyderabad
Msbi Online Training in India