|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-bi-sql-server-integration-service-ssis-course/
课程评论：没有评论
课程名称：Microsoft BI - SQL Server Integration Service (SSIS)课程 课程概述：本课程涵盖了SSIS的基础知识到高级应用。SQL Server集成服务（SSIS）使得创建强大而复杂的数据提取、转换和加载（ETL）解决方案变得简单。学员将学习如何设计、创建、部署和管理解决方案，以满足日常业务需求。SSIS可用于数据迁移和数据集成。 课程内容包括： 1. **控制流（Control Flow）**：了解任务执行的工作流程和任务执行的顺序，控制SSIS包的执行流程。 2. **数据流（Data Flow）**：掌握ETL过程，包括从多个数据源提取数据、执行转换以及利用目标适配器将数据加载到一个或多个目标。 3. **事件处理程序（Event Handlers）**：实现SSIS包中控制流任务的错误处理和调试。 4. **包资源管理器（Package Explorer）**：浏览包的内容，包括任务、优先顺序约束、日志提供程序、变量、事件处理程序和连接管理器。 5. **参数（Parameters）**：了解SSIS当前版本中配置的替代品，允许在包执行时为包内属性分配值。 6. **连接管理器（Connection Manager）**：维护包中不同任务和适配器使用的所有连接，连接管理器是连接的逻辑表示。 通过本课程，学员将能够全面掌握SSIS的使用，为其数据处理的实际应用打下坚实的基础。
This course covers SSIS from Basics to Advanced LevelsSSIS - SQL Server Integration ServicesSSIS:SSIS makes it easy to create robust and complex solutions for extracting, Transforming and Loading the data.These will help you to design, create, deploy and manage packages that address everyday business requirements.SSIS can be used for data migration as well as data integration purpose.Sections in SSIS Designer:Control Flow:Work flow of task execution / order of tasks execution.Controlling the flow of SSIS package execution.Data Flow: ETLIt contains extracting the data from one more sources with the help of source adapters, performing transformations and loading the data into one more destinations with the help of destination adapters.Event Handlers:It allows you to implement error handling and debugging of control flow tasks in SSIS packages.Package Explorer:It allows you to browse the package contents. Package contains tasks, precedence constraints, log providers, variables, event handlers and connection managers.Parameters:Parameters are the replacement for configurations that are in the current version of SSIS. It allows you to assign values to properties within packages at the time of package execution.Connection Manager:It maintains all connections used by the different tasks and adapters in the package.A connection manager is a logical representation of a connection
