Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Top 10 Things You Didn't Know About SSIS in SQL Server Code Name "Denali"

PASS Data Community Summit via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Discover the hidden gems of SQL Server Integration Services (SSIS) in the "Denali" release through this comprehensive conference talk. Explore beyond the well-known major improvements like enhanced Developer Experience, Project & Parameter model, and new Server-based deployment features. Delve into hundreds of customer-reported Connect issues that have been resolved, making this the highest quality release to date. Learn about the SSIS Catalog, CDC Service, artifacts, tools, and goals. Gain insights into Connection Managers and Flat File Improvements through demonstrations. Understand the new Designer Configuration, Parameter UI, and Troubleshooting Logging features. Explore data taps, binary data handling, and Server Management capabilities. Get hands-on with PowerShell for creating catalogs and running packages. Analyze performance breakdowns and interact with the Execution UI. This talk covers a wide range of topics, ensuring you'll uncover valuable information to enhance your SSIS experience in SQL Server "Denali."

Syllabus

Introduction
Projects and Parameters
SSIS Catalog
CDC Service
CDC artifacts
CDC tools
CDC goal
Connection Managers
Flat File Improvements
Demo
New Designer
Configuration
Parameter UI
Demos
Troubleshooting Logging
Data taps
Binary data
Server Management
PowerShell
Create Catalog
Running a Package
Performance Breakdown
Interactive Execution UI
Clean Up Before I Forget

Taught by

PASS Data Community Summit

Reviews

Start your review of Top 10 Things You Didn't Know About SSIS in SQL Server Code Name "Denali"

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.