SQL Server Integration Service (SSIS) is a data Integration tool which extracts data from multiple heterogeneous sources and can load the data to multiple different destinations.

Following are components of SSIS:

Control Flow
Data Flow
Event Handler
Package Explorer
Parameters
SSIS Tasks:

File System Task
FTP Tasks
Script Task
Send Mail Task
Bulk Insert Task
Script Task
Web Service Task
XML Task
Transformation Steps:

Aggregation
Conditional Split
Data Conversion
Derived Column

Lookup Transformation
Merge Join
Union and Union All
Sort
Fuzzy Lookup
Fuzzy Grouping
Percentage Sampling
and much more
Skillshare.SQL.Server.Integration.Services.SSIS.Ultimate.Training-SkilledHares

Title: SQL Server Integration Services (SSIS) Ultimate Training
Publisher: Skillshare
Category: Business
Size: 3450M
Files: 11F
Date: 2021-04-23
Course #: 1309116762
Published: Skillshare
Updated: N/A
URL: https://www.skillshare.com/classes/SQL-Server-Integration-Services-SSIS-Ultimate-Training/1309116762?category=business
Author: Saad Qureshi
Duration: 4h 23m
Exer/Code:

Installation:
Unpack that shit, run that shit

Description:
Insert generic comment here