Scenario 7: How to send first half records to target? How to achieve this in SSIS in various ways....(inlcuding any SQL quries)......? Thanks and Regards, Desparado.

explain yourself (or your school project/assignment)Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

by using "Row Sampling" or "percentage sampling" transforamtions we can achieve this right........? Correct me if Iam wrong....

by using "Row Sampling" or "percentage sampling" transforamtions we can achieve this right........? Correct me if Iam wrong.... Wrong... use the same methods as in your thread about the second half: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/631bb70f-0b38-43c0-b47e-665ab2ec0f50 Solution A) 1) get total number of records. 2) add rownumber 3) add conditional split with expression like rownumber <= (numberofrows /2) Solution B) Do something with the TOP statement in SQL SELECT TOP(SELECTcount(*)/ 2 FROM YourTable)* FROM YourTable ORDER BY myKey ASC Solution C) Do something with the TSQL statement row_number Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com