SQL Server Integration Services is an ETL tool that is part of Microsoft SQL Server. SSIS is a Rapid Application Development tool that comes with a powerful IDE named SQL Server Data Tools (SSDT).
SSDT was formerly known as Business Intelligence Development Studio (BIDS). There are lots of built-in components in SSIS that help to cover all aspects of an ETL solution. Apart from that, there are many other features such as event handling, buffer configuration, and the ability to work with different types of data sources, thereby making SSIS a great ETL tool.
SSIS was released with this name for the first time in 2005, but prior to that, it was named Data Transformation Services (DTS). DTS was available even in SQL Server 2000, and it improved a lot since that year. As of today, this tool has gone a long way to become a mature technology for ETL and data transformation.
SSIS has an engine that is installed...