I have a doubt with Activities DatabaseConnect, Excute Query and Disconnect.
I always use this 3 activities in this Order.
1- Connect. Where I configure my connection String and Provider name and in the Output y save the connection in a DataBaseConnection variable.
2- Execute Query. Using “Existing Connection” Propetie, where I Write the DataBaseConnection variable.
3- Disconnect. To close the connection Database.
But Today I Change the Activities order.
3 -Execute Query
And the Workflow works smoothly.
How can be It possible?