May 3, 2011 at 11:57 am
I am using Oracle Destination component by Attunity in my SSIS package. In the Oracle Connection Manager, I used a variable in the expression portion for the connection string. The variable is getting populated from the xml config file with [font="Courier New"]Data Source=aht1;User ID=***;Password=***;Provider=OraOLEDB.Oracle.1;Persist Security Info=True[/font].
When I update the value of the variable as [font="Courier New"]Data Source=ahp1;User ID=***;Password=***;Provider=OraOLEDB.Oracle.1;Persist Security Info=True [/font]in the xml config file, the value of the variable changes. But when I open Oracle Connection Manager, TNS service name is still aht1 instead of ahp1.
Can anyone help me with this connection string issue?
Thanks!
May 3, 2011 at 1:06 pm
The value of the connectionstring is only updated at runtime. The one your looking at in the package is the "design time default".
Check if your connection string changes when the package is running.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 10, 2011 at 7:36 am
A good tool to provide visual cues if connection strings are being configured elsewhere is BIDS Helper[/url]. If your connection string is being set by a package configuration, a Blue triangle appears on the connection manager. If it's set by an expression, then a Pink triangle appears on the connection manager. It's a very handy BIDS add-on indeed.
May 11, 2011 at 8:00 am
Thank you for that useful information!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply