SQL Server Integration Services (SSIS) as an on-premises ETL platform has been around for a very long time – more than 15 years I believe – an eternity in the Internet/cloud computing age. During that time, a lot of investments have been made to extend its data extraction/transformation/ingestion capabilities with additional components beyond the built-in ones that are bundled with SQL Server.
These additional components come out-of-the-box to be downloaded separately and installed on local/production machines for designing SSIS packages/running SSIS workloads. They include:
Custom Setup Interface for SSIS IR
In 2018, when we released SSIS as an ETL Platform as a Service (PaaS) in Azure Data Factory (ADF), we made sure that all these additional components can still be installed on SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS workloads – via a custom setup interface, see https://techcommunity.microsoft.com/t5/SQL-Server-Integration-Services/Enterprise-Edition-Custom-Set....
The custom setup interface provides almost limitless possibilities to customize your SSIS IR – Essentially, anything you can install on your SSIS machine on premises, you can also install on SSIS IR using this interface. Unfortunately, with great flexibility comes great complexity, as this interface requires you to do the following:
After a period of time, we noticed that there are common/popular custom setups that are repeatedly configured by many users when they provision their SSIS IR, so we’ve decided to make life a little bit easier for them and those who follow them later by introducing express custom setups.
Express Custom Setups for SSIS IR
Express custom setups are common/popular/selected custom setups that have been deeply integrated into SSIS IR, such that you need not prepare any scripts to configure them nor bring your own blob container in Azure Storage to store associated files. It’s as simple as selecting your express custom setup types when provisioning SSIS IR and entering the values for relevant custom setup arguments. At the time of writing, we’ve released the following express custom setup types:
I hope you’ll find these express custom setups useful and please don’t hesitate to contact us if you have any feedbacks/questions/issues on using them or suggestions for more common/popular custom setups to integrate into SSIS IR. Thank you as always for your support.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.