Scena rio 14: How to load every nth row from a Flat file/ relational DB to the target? Suppose n=3, then in above condition the row numbered 3,6,9,12,....so on, This example takes every 3 row to target table. How to achieve this in SSIS in various ways....(inlcuding any SQL quries)......? Thanks and Regards, Desparado.

you can use Script Component as source and write your own .NET Code to fetch every nth rows, this is a sample of script component as source: http://www.rad.pasfu.com/index.php?/archives/38-Script-Component-as-Source-SSIS.htmlhttp://www.rad.pasfu.com

What a weird question/assignment... Use a Script Component with some .net code or a conditional split with a modulo expression.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com