I am trying to connect to Oracle cliet in "Execute Sql task" of SSIS. I am able to add the connection and the Test Connection is succeeded.
But when I click on 'OK' to save it,it gives an error " The given path's format is not support"
The problem comes because of the Port Number. If we remove the port number it works(it takes default one).
But I want to connect through a specific Port Number.Then its giving the error.
Please let me know if faced this problem..!!!!
Connection Manager
According to \u\rarediamond in the MSDN link, following is one of the workaround for the problem:
1. Error occurs due to there being ":" in the server name field before the port number.
2. Remove the ":" from the server name field and click OK.
3. Open properties of the saved connection.
4. Add the ":" back in before the port number. This should be able to resolve the issue.
Some discussion about this in the following MSDN link.
If you are running 64-bit version that may be the problem.
I was having the same issue, uninstalled 64-bit version, installed 32 bit version, and now everything is working fine
Create new entry in tnsnames.ora file for your connection, then call it in your SSIS package
