November 3, 2016 at 10:46 am
Hi all, we are embarking on something we haven't done before and was hoping to short cut some of the "gotchas" we will likely encounter along the way by asking for advice from anyone who has been there and done that.
Situation: Multi-package SSIS implementation that will move/transform data from SQL Sever to SQL Azure (2014). Packages will be triggered on demand, using a .Net application, by an end-user when new data arrives. Source database size will vary, but will be significant enough in size to take into consideration (not terabytes, but gigabytes). The .Net app will pass in package parameters that it gets from the source db. We are not using project parameters (to my knowledge), so each package is called in sequence by the app.
The SQL Server which will run the SSIS packages will be on a VM, not sure yet whether it will be on-prem or IaaS in Azure. Is one better than the other? I'm guessing Azure due to data movement.
I think the VM will have to be in the same virtual network as the SQL Azure instance too correct?
Hopefully this is enough info to elicit advice.
TIA.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply