We import the Automation package from another DB.
The export dataset is not taking the current DB connection details; it's trying to use OLD DB details.
Automation Designer actions requiring a connection are bound to a connection. They do not operate on the active connection. You can edit your action's properties and change the connection that it is bound to.
Alternatively, you can select which connection an action is executed against via the rt-click menu.
Hi Michael, Thank you for your prompt reply.
Your suggestion is working; I am able to connect to the active connection.
About 500 automation packages need to be updated.
Is it possible for me to complete it all at once?
You can multi-select actions and apps. The rt-click menu of each has Change connections... menu item.
Michael