Welcome to the Northwest Ohio SQL PASS Chapter

Next Meeting

Wednesday,

March

11

Brian Davis - SSIS Templates Can Make Your Life Easier

  • In-Person @ 333 N Summit St. Toledo, Ohio, United States (map)
  • 18:00 - 20:00 Eastern Daylight Time
  • Language: English

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.

 



 Please register on EventBrite so we know how much food to order and we can coordinate with building security.  (If entering the building after 6pm, please use the after-hours door on N. St Clair St.)

 

This meeting is made possible by WTA Inc. (www.wtainc.com) and HCR ManorCare (www.hcr-manorcare.com). 

Featured Presentation:

SSIS Templates Can Make Your Life Easier

Brian Davis, Product Integration Engineer SentryOne

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.

About Brian:
Brian Davis is a Product Integration Engineer at SentryOne 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 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.

cage-aids
cage-aids
cage-aids
cage-aids