| Task Name | Description | Counterpart in SQL Server 2000 DTS | New with SSIS |
| Active X Script | Executes a script. This task is deprecated with SSIS and is intended solely for backward compatibility with DTS. For all new development you must use Script task. | Active X Script | N |
| Analysis Service Processing | Processes Analysis Services dimensions, measure groups, cubes databases. | Analysis Service Processing | N |
| Bulk Insert | Bulk loads data into SQL Server tables. | Bulk Insert | N |
| Execute SQL | Executes Transact-SQL statements or stored procedures. | Execute SQL | N |
| Execute Process | Executes a command line process; for example, a set of commands in a batch file. | Execute Process | N |
| File Transfer Protocol | Either uploads or downloads files using FTP. | File Transfer Protocol | N |
| Message Queue | Sends and receives string, variable and data file messages while executing the SSIS package. | Message Queue | N |
| Send Mail | Sends an email message. | Send Mail | N |
| Transfer Database | Copies database from one server / instance to another. | Transfer Database | N |
| Transfer Error Messages | Copies user defined error messages from one SQL Server instance to another. | Transfer Error Messages | N |
| Transfer Jobs | Transfers job definitions from one SQL Server instance to another. | Transfer Jobs | N |
| Transfer Logins | Transfers logins from one SQL Server instance to another. | Transfer Logins | N |
| Transfer SQL Server Object | Transfers any object from one SQL Server instance to another. | Copy SQL Server Object | N |
| Data Mining Query | Executes data mining prediction queries against Analysis Services. | Data Mining Prediction | N |
| Execute DTS 2000 Package | This task is deprecated and is intended solely for backward compatibility. Used specifically for executing DTS 2000 packages. | Execute Package | N |
| Transfer Master Stored Procedures | Transfers user-defined stored procedures which reside in master database from one instance to another. | Transfer Master Stored Procedures | N |
| Data Flow Task | Transforms and/or transfer data from one data source to another. This is the most important task in SSIS. | Transform Data | No, but it has changed significantly. |
| Backup Database | Backups one or multiple databases on a given instance of SQL Server. | None | Y |
| Check Database Integrity | Checks integrity of a single or multiple SQL Server databases with DBCC CHECKDB statement. | None | Y |
| Execute SQL Server Agent job | Executes a job on a given instance of SQL Server. | None | Y |
| Execute T-SQL Statement | Identical to Execute SQL task. | Execute SQL | N |
| Execute Package | Executes another SSIS package. | None | Y |
| History Cleanup | Deletes the maintenance plan history, job history and backup history for a given instance of SQL Server. | None | Y |
| Maintenance Cleanup | Deletes old backup files and maintenance plan report files. | None | Y |
| Notify Operator | Notifies SQL Server operator through email, pager or net send. | None | Y |
| Rebuild Index | Rebuilds indexes on one or multiple SQL Server tables and views. | None | Y |
| Reorganize Index | Reorganizes indexes on one or multiple SQL Server tables and views. | None | Y |
| Shrink Database | Executes DBCC SHRINKFILE on one or multiple SQL Server databases. | None | Y |
| Update Statistics | Executes UPDATE STATISTICS statement against chosen tables / views within one or multiple SQL Server databases. | None | Y |
| Analysis Services Execute DDL | Executes XML for Analysis (XMLA) statements to create, alter, drop or process Analysis Services objects. | None | Y |
| File System | Copies, moves, deletes or renames files and directories. This task is useful for reading all files within a given directory. | None | Y |
| Web Service | Executes a web method. | None | Y |
| XML | Applies XML operation to a previously retrieved XML document. | None | Y |
| WMI Data Reader | Reads Windows Management Instrumentation (WMI) data about the system. | None | Y |
| WMI Event Watcher | Queries and responds to WMI events. | None | Y |