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 UTC
  • Language: English

L.A. SQL Server Professional Group Meeting

Featured Presentation:

SSIS Project Deployment: The T-SQL Way

Peter Kral, Lead Database Engineer FTD

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:
Certified SQL Server MCSA 2012/2014/2016 and Data Platform MCSE, Peter was the winner of the Speaker Idol Award at PASS Summit 2016. Employed at e-commerce company FTD, he develops database solutions using T-SQL, SSIS and PowerShell. Peter is an active member in the PASS SQL Server User Group in San Diego, and has spoken at many SQL Saturdays, SoCal Code Camps, and at PASS Summit 2017.

Back to Top