Home Forums Data Warehousing Integration Services How to use same connection manager in different control flow tasks? RE: How to use same connection manager in different control flow tasks?

  • Not sure if this will solve your issue.

    Create a connection and copy the connect string from properties.

    Add a new variable and call it ParameterString of type string. Paste the connection string as its value. Set the EvaluuteAsExpression to TRUE

    Go back to the connection and set the expression ConnectionString to @ConnectionString.

    My thinking is that every time it runs, a new connection is created.

    Let me know how this works out.

    ian

    Ian Cockcroft
    MCITP BI Specialist