If you are in the DFW area, come down to the Forth Worth SQL Server User Group tonight at the Frees and Nichols Headquarters. The meet and greet starts at 6:30pm and the presentation follows at 7pm. I’ll be giving an updated version of the following presentation.
SSIS Performance Tuning with BimlScript
You know that Biml can automate ETL loads, but your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following:
– Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
– Automatically execute each package multiple times and record the results for analysis.
– Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
Anyway, additional details about the meeting can be found here. Hope to see some of you there!