I have a one time data pull from Oracle , but do not have Oracle driver deployed on the SSIS/SQL server. I have the Oracle driver deployed on another server in the same environment where I also have SSDT. I created a DF in SSDT to pull this data, but noticed that SSDT creates dynamic ports. Wondering if I can assign static port(s) to the SSDT data flow task, basically to the data source connection manager, so that I do not have any issue on the firewall. This is mostly a one time and pulling one large table