Forum Discussion
Unable to use On-Prem SQL Server Database as Data Destination in Dataflow Gen2
I am trying to find a way to load data from my Azure Data Warehouse to our On-Prem SQL Server Database and it seems like this is simply not possible to do since there is some kind of error or limitat...
I'm not sure dataflows officially support SQL Server as a destination, but I just tried it and it worked. It must use an on prem data gateway, and you must disable staging.
Soon Pipelines will also be supported on the On Prem data gateway, which officially support SQL Server as a destination.