Hi @Ruwan P,
TNS service name
Input the name of the Oracle database you work with. The TNS service name could be:
The connection name defined in the tnsnames.ora file
EzConnect format: [//]host[:port][/service_name]
To use a tnsnames.ora file, you may need to add a system environment variable to the machine running the SSIS package. The TNS_Admin environment variable specifies the location of the folder that contains the tnsnames.ora file. This will be required if you have not installed an Oracle client. To add the environment variable in Windows 10, Windows 11 or Windows Server 2022:
- Right-click the Start icon and select System.
- In the Settings window, select Advanced System Settings.
- On the Advanced tab of the System Properties window, select Environment Variables.
- In the Environment Variables window under System, select New.
- In the New System Variable window, enter "TNS_Admin" for the Variable name and the correct path to the folder that contains your tnsnames.ora file for the Variable value.
- Select OK in the New System Variable, Environment Variables, and System Properties windows.
For more information, see the Oracle documentation.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.