Their are many approaches to get alternate record from SQL server database table. Here i have discussed 2 approaches1. Complex Query2. Using Views Complex Query: SELECT...
Generating Row Number in SSIS for each record. Steps for Generating Row Numbers are: Step 1: Add Data Flow.