Hi All , Can anyone please guide me about SSIS Package optemization any related link will also be very useful Many Thanks in advance. Regards, Amitesh Srivastva

Here's a link: http://letmebingthatforyou.com/?q=ssis%20package%20optimisation Seriously, if you want a useful answer you're going to have to ask useful questions. What on earth do you mean by "SSIS Package Optimisation"? Put yourself in the shoes of someone replying here, how should we answer that?http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Check out the following links (in no particular order) on SSIS optimization. Let us know if helpful. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Top 10 SQL Server Integration Services Best Practices http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx Architecture of Integration Services http://msdn.microsoft.com/en-us/library/bb522498.aspx Integration Services: Performance Tuning Techniques http://technet.microsoft.com/en-us/library/cc966529.aspx Optimizing SSIS Package Performance – Part 1: The Data Flow Task http://ssisbi.com/optimizing-ssis-package-performance-part-1/ Optimizing SSIS Package Performance – Part 2: The Data Flow Components http://ssisbi.com/optimizing-ssis-package-performance-part-2-the-data-flow/ SQL Server 2005 SSIS: Tuning the Dataflow Task http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/ Comparing Overhead on the Execution Methods http://www.sqlis.com/sqlis/post/Comparing-Overhead-on-the-Execution-Methods.aspx Speeding up Reading from a SQL OLE DB or ADO.Net Data Source http://henkvandervalk.com/speeding-up-reading-from-a-sql-ole-db-or-ado-net-data-source SSIS : Conditional Split optimization http://sqlserverpedia.com/blog/sql-server-bloggers/ssis-conditional-split-optimization/ SQL Server 2005 Integration Services: A Strategy for Performance http://technet.microsoft.com/en-us/library/cc966530.aspx We Loaded 1TB in 30 Minutes with SSIS, and So Can You http://msdn.microsoft.com/en-us/library/dd537533(SQL.100).aspx SSIS 2008 Lookup Caching… http://www.networkworld.com/community/node/57997 SSIS - An Inside View Part 4 http://www.sql-server-performance.com/articles/biz/SSIS_An_Inside_View_Part_4_p1.aspx SSIS New Features in SQL Server 2008 - Part 4 http://www.sql-server-performance.com/articles/biz/SSIS_New_Features_in_SQL_Server_2008_Part4_p1.aspx SQL SERVER – Stored Procedure Optimization Tips – Best Practices http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-stored-procedure-optimization-tips-%E2%80%93-best-practices/ Performance Reporting for SSIS Packages. http://weblogs.sqlteam.com/jamesn/archive/2008/02/11/60504.aspx Best Practices for Integration Services Configurations http://technet.microsoft.com/en-us/library/cc671628.aspx Defining a Configuration Approach for Integration Services Packages http://technet.microsoft.com/en-us/library/cc671625.aspx Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series) http://sqlcat.com/presentations/archive/2009/05/02/designing-and-tuning-for-performance-your-ssis-packages-in-the-enterprise-sql-video-series.aspx Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video) http://msdn.microsoft.com/en-us/library/dd795225(SQL.100).aspx SSIS 2008 Import/Export Wizard Demo Video http://www.youtube.com/watch?v=9Wmdhnx1niU SSIS Performance Testing , Measurement and Optimization Video Tutorials http://siddhumehta.blogspot.com/2010/05/ssis-performance-testing-measurement.html Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Check out the following links (in no particular order) on SSIS optimization. Let us know if helpful. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Top 10 SQL Server Integration Services Best Practices http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx Architecture of Integration Services http://msdn.microsoft.com/en-us/library/bb522498.aspx Integration Services: Performance Tuning Techniques http://technet.microsoft.com/en-us/library/cc966529.aspx Optimizing SSIS Package Performance – Part 1: The Data Flow Task http://ssisbi.com/optimizing-ssis-package-performance-part-1/ Optimizing SSIS Package Performance – Part 2: The Data Flow Components http://ssisbi.com/optimizing-ssis-package-performance-part-2-the-data-flow/ SQL Server 2005 SSIS: Tuning the Dataflow Task http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/ Comparing Overhead on the Execution Methods http://www.sqlis.com/sqlis/post/Comparing-Overhead-on-the-Execution-Methods.aspx Speeding up Reading from a SQL OLE DB or ADO.Net Data Source http://henkvandervalk.com/speeding-up-reading-from-a-sql-ole-db-or-ado-net-data-source SSIS : Conditional Split optimization http://sqlserverpedia.com/blog/sql-server-bloggers/ssis-conditional-split-optimization/ SQL Server 2005 Integration Services: A Strategy for Performance http://technet.microsoft.com/en-us/library/cc966530.aspx We Loaded 1TB in 30 Minutes with SSIS, and So Can You http://msdn.microsoft.com/en-us/library/dd537533(SQL.100).aspx SSIS 2008 Lookup Caching… http://www.networkworld.com/community/node/57997 SSIS - An Inside View Part 4 http://www.sql-server-performance.com/articles/biz/SSIS_An_Inside_View_Part_4_p1.aspx SSIS New Features in SQL Server 2008 - Part 4 http://www.sql-server-performance.com/articles/biz/SSIS_New_Features_in_SQL_Server_2008_Part4_p1.aspx SQL SERVER – Stored Procedure Optimization Tips – Best Practices http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-stored-procedure-optimization-tips-%E2%80%93-best-practices/ Performance Reporting for SSIS Packages. http://weblogs.sqlteam.com/jamesn/archive/2008/02/11/60504.aspx Speeding Up SSIS Bulk Inserts into SQL Server http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server Best Practices for Integration Services Configurations http://technet.microsoft.com/en-us/library/cc671628.aspx Defining a Configuration Approach for Integration Services Packages http://technet.microsoft.com/en-us/library/cc671625.aspx Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series) http://sqlcat.com/presentations/archive/2009/05/02/designing-and-tuning-for-performance-your-ssis-packages-in-the-enterprise-sql-video-series.aspx Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video) http://msdn.microsoft.com/en-us/library/dd795225(SQL.100).aspx SSIS 2008 Import/Export Wizard Demo Video http://www.youtube.com/watch?v=9Wmdhnx1niU SSIS Performance Testing , Measurement and Optimization Video Tutorials http://siddhumehta.blogspot.com/2010/05/ssis-performance-testing-measurement.html Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

There is also a sticky post at the top of this forum for FAQs perhaps try that as well - http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/24d6967c-a11a-488a-9811-bd50a1a98322http://www.sqlis.com | http://www.konesans.com

Check out the following links (in no particular order) on SSIS optimization. Let us know if helpful. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Top 10 SQL Server Integration Services Best Practices http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx Architecture of Integration Services http://msdn.microsoft.com/en-us/library/bb522498.aspx Integration Services: Performance Tuning Techniques http://technet.microsoft.com/en-us/library/cc966529.aspx Optimizing SSIS Package Performance – Part 1: The Data Flow Task http://ssisbi.com/optimizing-ssis-package-performance-part-1/ Optimizing SSIS Package Performance – Part 2: The Data Flow Components http://ssisbi.com/optimizing-ssis-package-performance-part-2-the-data-flow/ SQL Server 2005 SSIS: Tuning the Dataflow Task http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/ Comparing Overhead on the Execution Methods http://www.sqlis.com/sqlis/post/Comparing-Overhead-on-the-Execution-Methods.aspx Speeding up Reading from a SQL OLE DB or ADO.Net Data Source http://henkvandervalk.com/speeding-up-reading-from-a-sql-ole-db-or-ado-net-data-source SSIS : Conditional Split optimization http://sqlserverpedia.com/blog/sql-server-bloggers/ssis-conditional-split-optimization/ SQL Server 2005 Integration Services: A Strategy for Performance http://technet.microsoft.com/en-us/library/cc966530.aspx We Loaded 1TB in 30 Minutes with SSIS, and So Can You http://msdn.microsoft.com/en-us/library/dd537533(SQL.100).aspx SSIS 2008 Lookup Caching… http://www.networkworld.com/community/node/57997 SSIS - An Inside View Part 4 http://www.sql-server-performance.com/articles/biz/SSIS_An_Inside_View_Part_4_p1.aspx SSIS New Features in SQL Server 2008 - Part 4 http://www.sql-server-performance.com/articles/biz/SSIS_New_Features_in_SQL_Server_2008_Part4_p1.aspx SQL SERVER – Stored Procedure Optimization Tips – Best Practices http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-stored-procedure-optimization-tips-%E2%80%93-best-practices/ Performance Reporting for SSIS Packages. http://weblogs.sqlteam.com/jamesn/archive/2008/02/11/60504.aspx Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series) http://sqlcat.com/presentations/archive/2009/05/02/designing-and-tuning-for-performance-your-ssis-packages-in-the-enterprise-sql-video-series.aspx Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video) http://msdn.microsoft.com/en-us/library/dd795225(SQL.100).aspx SSIS 2008 Import/Export Wizard Demo Video http://www.youtube.com/watch?v=9Wmdhnx1niU SSIS Performance Testing , Measurement and Optimization Video Tutorials http://siddhumehta.blogspot.com/2010/05/ssis-performance-testing-measurement.html Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Check out the following links (in no particular order) on SSIS optimization. Let us know if helpful. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Top 10 SQL Server Integration Services Best Practices http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx Architecture of Integration Services http://msdn.microsoft.com/en-us/library/bb522498.aspx Integration Services: Performance Tuning Techniques http://technet.microsoft.com/en-us/library/cc966529.aspx Optimizing SSIS Package Performance – Part 1: The Data Flow Task http://ssisbi.com/optimizing-ssis-package-performance-part-1/ Optimizing SSIS Package Performance – Part 2: The Data Flow Components http://ssisbi.com/optimizing-ssis-package-performance-part-2-the-data-flow/ SQL Server 2005 SSIS: Tuning the Dataflow Task http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/ Comparing Overhead on the Execution Methods http://www.sqlis.com/sqlis/post/Comparing-Overhead-on-the-Execution-Methods.aspx Speeding up Reading from a SQL OLE DB or ADO.Net Data Source http://henkvandervalk.com/speeding-up-reading-from-a-sql-ole-db-or-ado-net-data-source SSIS : Conditional Split optimization http://sqlserverpedia.com/blog/sql-server-bloggers/ssis-conditional-split-optimization/ SQL Server 2005 Integration Services: A Strategy for Performance http://technet.microsoft.com/en-us/library/cc966530.aspx We Loaded 1TB in 30 Minutes with SSIS, and So Can You http://msdn.microsoft.com/en-us/library/dd537533(SQL.100).aspx SSIS 2008 Lookup Caching… http://www.networkworld.com/community/node/57997 SSIS - An Inside View Part 4 http://www.sql-server-performance.com/articles/biz/SSIS_An_Inside_View_Part_4_p1.aspx SSIS New Features in SQL Server 2008 - Part 4 http://www.sql-server-performance.com/articles/biz/SSIS_New_Features_in_SQL_Server_2008_Part4_p1.aspx SQL SERVER – Stored Procedure Optimization Tips – Best Practices http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-stored-procedure-optimization-tips-%E2%80%93-best-practices/ Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series) http://sqlcat.com/presentations/archive/2009/05/02/designing-and-tuning-for-performance-your-ssis-packages-in-the-enterprise-sql-video-series.aspx Tuning Your SSIS Package Data Flow in the Enterprise (SQL Server Video) http://msdn.microsoft.com/en-us/library/dd795225(SQL.100).aspx SSIS 2008 Import/Export Wizard Demo Video http://www.youtube.com/watch?v=9Wmdhnx1niU SSIS Performance Testing , Measurement and Optimization Video Tutorials http://siddhumehta.blogspot.com/2010/05/ssis-performance-testing-measurement.html Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM