Scenario 9: How to send alternate record to target? Or Sending Odd numbered records to one target and even numbered records to another target. How to achieve this in SSIS in various ways....(inlcuding any SQL quries)......? Thanks and Regards, Desparado.

Use a Conditional Split and use an expression to figure out if your number is even or odd: @Value % 2 == 0? "even":"odd" Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Use a Conditional Split and use an expression to figure out if your number is even or odd.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

You could add a row number to the source data and use an expression to check if the rowid is an odd or even number and you could split them based on conditional split.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.