Adding an Oracle Data Source in SSIS

  • Windows Server 2003 DC 32-bit/MSSQL 2008 /Oracle Client 10.2

    I've tried adding various Oracle data sources in SSIS using:

    1. Oracle Provider for OLE DB

    2. .NET OracleClient Data Provider

    3. MS OLE DB Provider for Oracle

    When I configure and test connect, it succeeds. When I press OK to save it, I receive the following:

    "The given path's format is not support"

    I can make shared data source connections in Reporting Services, just not in Integration Services.

    Anyone have a clue as to what I doing incorrectly?

    Thanks ... Ken

  • Since we cannot see any screenshot or full error it's really hard to tell, init? 🙂

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Did you ever get a resolution to this

    Because i am getting the same messages.

    When i test the test connection succeeds.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply