Executing an SSIS package with an on-premises data store
We may have SSIS packages accessing an on-premises data source or the destination; for example, we may have files in an on-premises file store to be uploaded to Azure SQL Database, or we may have an on-premises database as the source. In such cases, we require the Azure SSIS IR to connect to the on-premises data store. There are two ways to do that:
- Configuring Azure SSIS to connect to on-premises using a Point-to-Site VPN, Site-to-Site VPN, or ExpressRoute. There are three steps to this:
1) Set up a Point-to-Site VPN, Site-to-Site VPN, or ExpressRoute between on-premises and Azure.
2) Create a virtual network and join the Azure SSIS IR with the virtual network.
3) Create a virtual network gateway.
- Configure Azure SSIS to use a self-hosted IR as a proxy to connect to on-premises.
In this recipe, we'll explore the second option. To get more information on option 1, you can check out https://docs.microsoft...