Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2010-04-06 : 11:55:19
|
| Im trying to connect to Oracle Dtabase 11g using script task in SSIS. Here is my connection stringDim str As String = "Provider=msdaora;Data Source=xxx\dw01;User Id=yyyy;Password=090909"[Here is the Oracle Databe Info]Server - xxxDb - dw01User - yyyyPassword - 090909I 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 ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-06 : 12:28:49
|
| just out of curiosity, what are you trying to do inside script task?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-04-06 : 13:07:19
|
| Im trying to connect to an Oracle Db, validate the contents of the data and count number of rows that are valid prior to loading the data.I was able to use the [OleDB Source] Connection Manager to select rows and dump to a flat file.I decided to use the Script Task instead, so that I can perform the validation and grab the data at one go. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-06 : 13:35:25
|
| cant you use rowcount task for that and use lookup for validating? what are your validation rules?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Error Connection to Oracle in Script Task