Lynchburg SQL Server Users Group

Next Meeting

Thursday,

February

26

Designing an SSIS Framework

  • In-Person @ 1 Mountain View Road Lynchburg, Virginia, United States (map)
  • 18:00 - 20:00 (UTC-05:00) Eastern Time (US & Canada)
  • Language: English

Map and directions located on our  Resources page.

 

Eventbrite - Designing an SSIS Framework

Featured Presentation:

Designing an SSIS Framework

Andy Leonard, CSO Linchpin People, LLC

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that integrates with the SSIS Catalog to manage package execution, connections, and centralized logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A workaround for SSIS Catalog limitations to SSIS package execution. 3) A workaround for SSIS Catalog limitations to reporting from the Catalog.

About Andy:
Andy Leonard is a consultant and trainer with Linchpin People, LLC. He is active in the SQL Server community, co-CSO of SQLPeople.net, and co-author of several books on SQL Server and Integration Services.