Hi ...what are optimization techniques available for package level...Give me examplesN.suresh

Refer this which talks about optimisations in SSIS....there are loads of reference materials available over the web...Google is a good starting point....if you have specific problems please post here....http://btsbee.wordpress.com/

Here are some performance best practices.... http://www.mssqltips.com/sqlservertip/1867/sql-server-integration-services-ssis-performance-best-practices/HTH, Cheers!! Ashish Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.