Post reply

Connection string issue with Oracle Destination component by Attunity

  • May 3, 2011 at 1:06 pm

    #1319344

    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

    #1322293

    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

    #1323030

    Thank you for that useful information!

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply