ADF - Azure Blog Storage Destination In SSIS - Lift and Shift
Enable SSIS packages to connect by proxy
When designing new packages containing Data Flow Tasks with OLEDB/Flat File Sources to access databases/files on-premises, you can enable this property by setting it to True on the Properties panel of relevant connection managers.