using variables in SSIS script task: c# code
-
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 :( can anybdy suggest? FBG
-
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 :( can anybdy suggest? FBG
bigphish wrote:
but its not working
Without some more information it's impossible even to make a guess.
Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman