L.A. SQL Server Professionals Group

Welcome to the Los Angeles SQL Server Professionals Group

Next Meeting




SSIS Project Deployment: The T-SQL Way

  • In-Person @ Microsoft Store, 10250 Santa Monica Blvd, #1045 Los Angeles, California, United States (map)
  • 18:30 - 21:00 Pacific Daylight Time
  • Language: English

L.A. SQL Server Professional Group Meeting

Featured Presentation:

SSIS Project Deployment: The T-SQL Way

Peter Kral, Premier Field Engineer Microsoft

Do you deploy SQL Server Integration Services (SSIS) Projects using the Integration Services Deployment Wizard? If you’re looking for a repeatable deployment method that can be source controlled, there’s another way…the T-SQL way! In this session, you will see a demonstration of T-SQL script deployment of SSIS projects, using stored procedures in the SSISDB database. You’ll learn how to query the SSIS catalog to find your project configurations so they can be captured and source controlled. Take control of your SSIS deployments…the T-SQL way! Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development. Goals: • Learn about the SSISDB database and catalog objects • See how to use T-SQL to deploy SSIS projects and packages • Discover the new features of SSIS delivered with SQL Server 2016

About Peter:
Peter Kral is a Premier Field Engineer (Data & AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.

PASS Summit 2019 Discount Code



WeStaffIT, Inc.





Back to Top