SQL Server Integration Services (SSIS) Ultimate Training
SQL Server Integration Services (SSIS) Ultimate Training
MP4 | Video: h264, 1278x720 | Audio: AAC, 48000 Hz
Language: English | Size: 3.35 GB | Duration: 4h 23m
MP4 | Video: h264, 1278x720 | Audio: AAC, 48000 Hz
Language: English | Size: 3.35 GB | Duration: 4h 23m
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