C# Programming
01-19-2012, 08:00 PM
hi all..
i am using script task in SSIS.i am new to it.
I have a oracle connection string in the code say:
//OraConn.ConnectionString = "User Id=XXXX;Password=xxxx;Data Source= (xxxxxxx));";now i want to access this conection via variable: OraConn. how to do it?
is it like below?
OraConn.ConnectionString = Dts.Variables["OraConn"].Value.ToString();but its not working http://www.barakasoft.com/script/Forums/Images/smiley_frown.gif can anybdy suggest?
FBG
i am using script task in SSIS.i am new to it.
I have a oracle connection string in the code say:
//OraConn.ConnectionString = "User Id=XXXX;Password=xxxx;Data Source= (xxxxxxx));";now i want to access this conection via variable: OraConn. how to do it?
is it like below?
OraConn.ConnectionString = Dts.Variables["OraConn"].Value.ToString();but its not working http://www.barakasoft.com/script/Forums/Images/smiley_frown.gif can anybdy suggest?
FBG