The export dataset is not using the current DB connection details.

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.