I would like to do ETL on every night. Is it good idea to use onpremise SSIS for ETL of Azure SQL? Any risks or performance issues? It is possible to install Azure SSIS VM if needed, but that creates more cost.
Running SSIS in Azure VM is a better solution for ETL for Azure SQL. You can avoid high network latency and potential cost for out bound traffic. And it is not necessary introducing more cost. Please see the following blog post for more details: https://blogs.msdn.microsoft.com/ssis/2017/01/05/running-ssis-on-azure-vm-iaas-do-more-with-less-money/
Regards,
Proposed as answer byAlberto MorilloMVPWednesday, March 22, 2017 7:35 PM
Marked as answer byKenny_IThursday, March 23, 2017 6:17 AM
Running SSIS in Azure VM is a better solution for ETL for Azure SQL. You can avoid high network latency and potential cost for out bound traffic. And it is not necessary introducing more cost. Please see the following blog post for more details: https://blogs.msdn.microsoft.com/ssis/2017/01/05/running-ssis-on-azure-vm-iaas-do-more-with-less-money/
Regards,
Proposed as answer byAlberto MorilloMVPWednesday, March 22, 2017 7:35 PM
Marked as answer byKenny_IThursday, March 23, 2017 6:17 AM
You can also create a Azure data factory with a "copy" pipeline activity to achieve this if you would like. You may have to create a gateway for your Onpremise SQL Server
Proposed as answer byAlberto MorilloMVPWednesday, March 22, 2017 7:35 PM
