Summary
SQL Server Integration Services is a data consolidation and ETL tool. SSIS provides many built-in tasks and components that help you to create the data transfer scenarios. An SSIS project contains one or more packages. Each SSIS package has a control flow design area that contains multiple tasks with their order of execution. There is also a Data Flow task that is the main part of ETL development; you can use the sources, transformations, and destination components to a great extent with different data providers and apply complex transformations. SSIS projects can be deployed to SSIS catalog, which is a central repository for Integration Services projects, and provides extensive logging and execution options.
SSIS is a vast topic that cannot ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide 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.
