-
Book Overview & Buying
-
Table Of Contents
Azure Data Engineering Cookbook
By :
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:
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.
In this recipe, we'll explore the second option. To get more information on option 1, you can check out https://docs.microsoft...