SQL PASS March Meeting -- SSIS Templates Can Make Your Life Easier
You are cordially invited to the March meeting of Northwest Ohio SQL PASS (Professional Association for SQL Server) on Wednesday March 11th, 6pm at HCR Manorcare Corporate Headquarters in Toledo, OH.
This month we have the honor to host Brian Davis (PASS Regional Mentor). Please be sure to attend and pass this invite along to other SQL minded professionals in the area.
Speaker Bio: Brian Davis is a SQL Server Consultant with UpSearch and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands on experience with SQL Server 2000-2014. Brian is also a Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Topic: SSIS Templates Can Make Your Life Easier
How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again. Finally we’ll take an introductory look at BIML (Business Intelligence Markup Language) and discover how you can dynamically generate SSIS packages.