From the course: Implementing a Data Warehouse with SQL Server 2022
Join today to access over 24,900 courses taught by industry experts.
Establish control flow - SQL Server Tutorial
From the course: Implementing a Data Warehouse with SQL Server 2022
Establish control flow
- [Instructor] Data flows are just one possible component of an SSIS package. An integration services package also allows you to automate a wide range of database activities, in addition to the standard ETL tasks found in a data flow. Together, this extended capability goes by the term control flow. Control flow tasks can perform routine database maintenance such as creating a backup or rebuilding indexes. They can also work with the file system and create folders and files on the local file system or on an FTP server. You can create a control flow task that sends an email to database administrators when a certain condition occurs, or run Transact-SQL commands on a database server. Control flow tasks can even incorporate looping containers that are useful for performing the same task multiple times. For instance, reading data out of a folder containing an unknown number of CSV flat files. The execution of tasks in a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.