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