Ohio North SQL Server User Group

Choose a meeting below to view its details


Meeting Archive

Tuesday,

July

05

ONSSUG July Meeting (7/5)

  • In-Person @ 6050 Oak Tree Blvd. Independence, Ohio, United States (map)
  • 17:00 - 20:00 Eastern Daylight Time
  • Language: English

RSVP: 

https://www.eventbrite.com/e/onssug-july-meeting-75-tickets-26257104707

5:00 - 6:00 -Pre-Session Video:

Living and Dying by Dynamic SQL

Doug Lane 
Track: Application & Database Development
Level: 200, General Session (75 minutes)

Featured Presentation:

Paul Hiles

The SSIS Catalog - What is it and Why should I use it.

 

The SSIS Catalog was introduced in SQL Server 2012. This session is going to explore what the catalog is and how it can improve the scheduling and tracking package executions. One of the biggest advantages to the SSIS Catalog is that it allows a single package to be ran with multiple environments without having to make any changes to the package. First, we will review some bonus material with SSIS project parameters. Then review their use with the catalog's environments. Next, the fun will begin with examining the catalog and using it to execute packages in different environments. Finally, we will take a look that the catalog's logging and database to monitor and review the packages executions.

Paul has over 20 years of experience in the IT field which includes: programmer, system administrator, technical manger and both an operational and application DBA. He has been working with SQL Server since 2000 starting with version 7.0. He is currently a Data Architect where he specializes in SSIS, SSRS and database design and performance tuning.

WHEN
WHERE
Microsoft Corporation - 6050 Oak Tree Blvd. Suite 300, Independence, OH 44131 - View Map

Featured Presentation:

The SSIS Catalog - What is it and Why should I use it.

Paul Hiles, Data Architech AmeriMark

The SSIS Catalog was introduced in SQL Server 2012. This session is going to explore what the catalog is and how it can improve the scheduling and tracking package executions. One of the biggest advantages to the SSIS Catalog is that it allows a single package to be ran with multiple environments without having to make any changes to the package. First, we will review some bonus material with SSIS project parameters. Then review their use with the catalog's environments. Next, the fun will begin with examining the catalog and using it to execute packages in different environments. Finally, we will take a look that the catalog's logging and database to monitor and review the packages executions.

About Paul:
Paul has over 20 years of experience in the IT field which includes: programmer, system administrator, technical manger and both an operational and application DBA. He has been working with SQL Server since 2000 starting with version 7.0. He is currently a Data Architect where he specializes in SSIS, SSRS and database design and performance tuning.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids