SSIS Components
Explore the rich set of components available in SQL Server Integration Services (SSIS) to build powerful and efficient data integration and transformation workflows.
Data Flow Components
Components that operate within the Data Flow Task to extract, transform, and load data.
Source Components
Extract data from various sources like databases, files, and cloud services.
View Details »Destination Components
Load transformed data into target systems, including databases, files, and cloud storage.
View Details »Control Flow Components
Components that define the workflow and execution logic of an SSIS package.
Tasks
Perform specific operations such as executing SQL, transferring files, or sending emails.
View Details »Common Tasks
Detailed information on frequently used tasks in control flow.
Data Flow Task
The core task for executing data extraction, transformation, and loading operations.
View Details »File System Task
Perform operations on files and directories, such as copying, moving, or deleting.
View Details »Data Flow Transformations
Key transformations for data manipulation within the Data Flow Task.
Connection Managers
Establish connections to various data sources and destinations.
Scripting Components
Leverage custom code for advanced logic.
Script Component (Data Flow)
Implement custom sources, transformations, or destinations in the data flow.
View Details »