CODEWITHSUNDEEP
oracle-databasessisbidsoledbconnection
Jeevika
Jeevika

Reputation: 165

Adding Oracle connection string in SSIS .Error :The given path's format is not support

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

enter image description here

enter image description here

enter image description here

Upvotes: 2

Views: 4198

Answers (3)

Abdelrahman Mangoud
Abdelrahman Mangoud

Reputation: 1

Create new entry in tnsnames.ora file for your connection, then call it in your SSIS package

Upvotes: 0

Meta747
Meta747

Reputation: 253

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.

Upvotes: 2

user5781068
user5781068

Reputation: 1

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

Upvotes: 0

Related Questions