Scenario 11: In Dept table there are four departments (dept no 40,30,20,10). Separate the record to different target department wise. How to achieve this in SSIS in various ways....(inlcuding any SQL quries)......? Thanks and Regards, Desparado.

Use conditional split on condition for department.Request to please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.

to know more about conditional split check msdn blog. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/