SQL Server Integration Services (SSIS) A Practical Approach Год выпуска: 2024 Производитель: Udemy Сайт производителя: https://www.udemy.com Автор: Uplatz Training Продолжительность: 18ч 30м Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Просьба не уходить с раздачи,я не смогу поддерживать раздачу вечно. Поделись халявой с другими людьми,не уходи с раздачи. Призывай других людей переходить на рутрекер. Курс на английском языке. Добавлены английские субтитры. A warm welcome to the SQL Server Integration Services: A Practical Approach course by Uplatz. SQL Server Integration Services (SSIS) is a powerful data integration and workflow tool in Microsoft SQL Server. It is designed to handle data migration, transformation, and integration tasks. Here’s a detailed description of SSIS and how it works: Overview of SSIS SSIS is part of Microsoft SQL Server and is used for building high-performance data integration and workflow solutions. It supports a wide range of data integration scenarios, including data warehousing, data migration, and data synchronization between different data sources. Key Components of SSIS Control Flow Tasks: These are the basic units of work in SSIS. They can perform a wide range of operations, such as executing SQL statements, sending emails, or transferring files. Containers: These provide structure to the control flow by grouping tasks together. Common containers include Sequence Containers, For Loop Containers, and Foreach Loop Containers. Precedence Constraints: These define the workflow logic by controlling the order in which tasks and containers are executed based on the success, failure, or completion of preceding tasks. Data Flow Data Flow Tasks: These handle the actual data movement and transformation. They are part of the control flow but focus specifically on the ETL process. Sources: These are the starting points for data in the data flow. They can connect to various data sources such as SQL Server, Oracle, Excel files, and more. Transformations: These operations modify and clean the data. Common transformations include sorting, aggregating, merging, and data conversion. Destinations: These are the endpoints for data in the data flow. Data is loaded into destinations such as databases, files, or other data stores. Event Handlers These allow you to define custom actions in response to events raised during package execution, such as OnError, OnWarning, OnPreExecute, and OnPostExecute events. Parameters and Variables Parameters are used to pass values into packages at runtime, making them dynamic and configurable. Variables are used to store values that packages can use during execution. Expressions Expressions enable dynamic property values based on conditions or variable values, allowing packages to adapt to changing conditions.
Содержание
Chapter 1-Introduction to SSIS Chapter 2-SSIS Terminologies Chapter 3-SSIS Features Chapter 4-SSIS Architecture Chapter 5-Import CSV File to SSIS Chapter 6-SSIS Tasks Chapter 7-Data Flow Task Chapter 8-Excel Connection Manager Chapter 9-SSIS Demo Chapter 10-SSIS Installation and Configuration Chapter 11-SSIS Components Chapter 12-Export Data to Excel File Chapter 13-Execute SQL Task Chapter 14-Export SQL Server Table to Flat File Chapter 15-Load Flat File Data to SQL Server Chapter 16-For Loop Container Chapter 17-For Each Loop Container Chapter 18-Bulk Insert Task Chapter 19-Import Fixed Width File Chapter 20-Import XML File Chapter 21-Load Excel Data into SQL Server Chapter 22-SSIS Merge Transformations Chapter 23-Remove Quotes from Data Chapter 24-Sequence Container Chapter 25-SSIS Execute SQL Task Chapter 26-Libary Stored Procedure Chapter 27-Functions in SSIS Chapter 28-Relationships in SSIS Chapter 29-SSIS Interview Questions
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum