SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software designed to perform a variety of tasks for data migration. SSIS is a platform intended for data integration and workflow applications. It is a powerful data warehousing tool created for the purposes of data extraction, transformation, and loading (ETL).
SSIS allows you to create packages that migrate data from a data source to a destination, applying transformations at the same time, if necessary. With its rich set of built-in tasks and transformations combined with a visual development tool based on Microsoft Visual Studio, that is called the SQL Server Business Intelligence Development Studio (BIDS), you can easily manage data flow tasks. Besides, you can keep track of the package execution through the color-coded, real-time monitoring feature of this tool.
Devart dotConnect for Oracle SSIS embeds into SQL Server Integration Services and thus enables data migration to and from Oracle.