Hi SSIS Masters,  

            I am trying to improve the performance of our ETLs (viz. MSSQL 2012 version) by editing the OLE DB Destination Editor values. 

            In my package, on a daily basis the source table has <= 50,000 rows of data (these are the number of rows that I have to pull every daily basis). Can I set the Rows per batch as 10,000 or 50,000. I am still trying to understand, on what factor this value must be decided? 

           Any suggestion for the above scenario is welcomed. 

Cheers,

Chandra.