SQL Server Integration Services training (SSIS) is a component of SQL Server that facilitates data extract, transformation, and loading (ETL).
SSIS can also be used to automate updates to databases and SQL server cubes.
SSIS can interact with a wide range of data formats, including all major modern databases, Excel, delimited text files, fixed-width text files, and XML.
You Will Learn How To
Solve data management problems by migrating and processing data
Perform nonstandard imports and exports using the Script component
Assemble tasks to perform complex data migrations
Extract, Transform, and Load (ETL) data
Incrementally migrate data from SQL Server data sources using Change Data Capture (CDC)
Deploy packages to an SSIS catalog