Table of Contents
Preface
Chapter 1: Getting Started with Azure and SSIS 2019
Technical requirements 14
Installing Microsoft SQL Server 2019 Integration Services 14
Getting ready 15
How to do it… 16
How it works… 31
Installing SQL Server Management Studio 31
Getting ready 32
How to do it… 32
How it works… 38
Installing SQL Server Data Tools 38
Getting ready 38
How to do it… 39
How it works… 43
Installing Azure Data Studio 43
Getting ready 43
How to do it… 44
How it works… 45
Creating an Azure subscription 45
Getting ready 46
How to do it… 46
How it works… 49
There's more… 49
Chapter 2: Introducing ETL
Creating a SQL Azure database 52
Getting ready 52
How to do it… 52
How it works… 60
Connecting SQL Management Studio ...
Get ETL with Azure Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
