Is there any way in which I can speed up data inserts in SSIS..... I am using an OLEDB data destination.Mr Shaw

Use Bulk Insert - FastLoad option.Arthur My Blog

should I tweek the batch and max commit settings?Mr Shaw

You can play around with this, but the SSIS engine finds the appropriate size most often very accurately. Besides, these parameters depend on the hardware. An article for you to skim through: http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/Arthur My Blog

yes you can check http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server#comments and also check http://henkvandervalk.com/reading-as-fast-as-possible-from-a-table-with-ssis-part-iiSincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).