March 1, 2010 at 1:06 pm
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
March 9, 2010 at 3:03 pm
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.November 14, 2013 at 10:39 am
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