What Is an SSIS Package and How Do You Create One?
SQL Server Integration Services (SSIS) is a workflow orchestration service used mostly for data integration and transformation. It was first released as part of SQL Server 2005 and continues to receive updates and new features today. While SSIS can be installed and run on a server (on-premises or in the cloud), it’s also available in Azure Data Factory. SSIS is commonly used to perform tasks such as: While SSIS originally only ran on Windows, it has also been available for Linux since 2017.