SSIS Tasks: Building Blocks of Data Integration
SSIS tasks are the fundamental building blocks of a package's control flow. They perform specific actions, such as executing SQL statements, sending e-mails, transferring files, or processing data. By combining various tasks, you can create complex data integration and transformation workflows.
Data Flow Task
The cornerstone of SSIS, the Data Flow Task, allows you to extract, transform, and load data from various sources to destinations.
Learn MoreExecute SQL Task
Run SQL statements or stored procedures against an OLE DB connection. Useful for data manipulation and control logic.
Learn MoreFile System Task
Perform file operations such as copying, deleting, renaming, or creating files and folders.
Learn MoreSend Mail Task
Send e-mail messages. Often used for notifications, error reporting, or distributing results.
Learn MoreFTP Task
Transfer files between a local computer and an FTP server. Supports upload and download operations.
Learn MoreScript Task
Write custom code using C# or Visual Basic.NET to perform actions not covered by standard tasks.
Learn MoreSequence Container
Group related tasks into a single unit, allowing for easier management and reusability.
Learn MoreForeach Loop Container
Iterate over a collection of objects, such as files in a folder or rows in a table, executing a set of tasks for each item.
Learn More