question

SeverHD-2139 avatar image
0 Votes"
SeverHD-2139 asked ZoeHui-MSFT answered

Can I assign static port(s) to SSDT data flow.

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

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Normally you define the IP port in the TnsNames.ora file, see https://www.connectionstrings.com/oracle/ => Omiting tnsnames.ora

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @SeverHD-2139 ,

SSDT creates dynamic ports

Not sure if SSDT could create dynamic ports.

To change the Oracle port you may refer: change-oracle-port-from-port

And I did some online research, I did not find any articles about assigning static port with SSDT data flow.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.