I'm new to sql server,so please help me to know about this.
1) whether the ssis package will process 1 row at a time or whole rows.
(i.e) it will take one record and process all the transformation then next or it will take all rows and process in each transformation.
2) how to assign a value to a variable at run time after each row processed.
Thanks and Regards