SQL Server Integration Services - Performance Tips and Tricks
by David Baldauff
Sun, Oct 01, 2006
Room:
Time:
0:00
High Performance SSIS data transformations are within your reach if you have the right know-how to do the job. In this presentation we will discuss how to best use SSIS to create high performance ETL processes. Documentation on SSIS performance considerations is not easy to come by, so in this presentation we will go through the major issues that you need to be aware of and plan for when high performance is a must. We will look at the actual performance differences using varying SSIS data transformations and other SSIS settings. You will come away with numerous techniques which will allow you to implement fast high volume data transformations.
About the Author
David Baldauff is a consultant with Digineer, a Microsoft Gold Certified and Managed Partner consulting firm in the Twin Cities. David specializes in data architecture, data-driven application development and database design and deployment. Since the release of SQL Server 2005 David has worked on several SQL Server 2005 deployments - in each case utilizing SSIS as the key tool for ETLs. David has over 13 years experience in the industry.