connecting oracle database with C# using SSIS

See more:

SSIS

i am making a SSIS package which uses certain C# script. in this script i need to connect to ORACLE database. I have used a variable to store a value of connection string but i can't connect my script to the Oracle Database by using the (connection string)value of this variable. The same connection string works in SSIS but i cant make connection using this string through my C# script.

heres the sample of code i used to get the connection string from the variable

string connn = Dts.Variables["OleDBConnString"].Value.ToString();
           OleDbConnection oCon = new OleDbConnection(connn);

and the value stored in the variable=Data Source=DEV.WORLD;User ID=GCAWARDSX; Password = gcawardsx;Provider=Microsoft OLE DB Provider for Oracle;Persist Security Info=True;