Connection string issue with Oracle Destination component by Attunity

  • 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!

  • 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

  • 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.

  • 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