Error Connecting to Oracle Database using script task
-
Im trying to connect to Oracle Dtabase 11g using script task in SSIS. Here is my connection string
Dim str As String = "Provider=msdaora;Data Source=xxx\dw01;User Id=yyyy;Password=090909"
[Here is the Oracle Databe Info]
Server - xxx
Db - dw01
User - yyyy
Password - 090909
I have used this is my script task "Imports System.Data.OleDb"
When I try to connect,I get the following exception back tns could not resolve the connect identifier specified
I cant move forward till the time Im able to connect to the server,Any suggestions ?
-
I did a Bing search for the exception message, and found this: http://ora-12154.ora-code.com/
Does it help?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
I was able to grab data from Oracle using the [Oledb Source] Connection Manager without any problems.
But I would like to use script task instead to connect, perform validation and grab data at one go.
Could someone verify if my connection string is correct ?
-
LOOKUP_BI-756009 (4/6/2010)
I was able to grab data from Oracle using the [Oledb Source] Connection Manager without any problems.But I would like to use script task instead to connect, perform validation and grab data at one go.
Could someone verify if my connection string is correct ?
Can you elaborate why do you want to use script task instead of using regular OLEDB Source?
I'm asking because using OLEDB from script is not easy. The OLEDB API is very low-level.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply