I've spent the last 2 days trying to get this to work but keep running into the same error. I'm trying to deploy a solution from a DEV environment to TEST environment as a managed solution.
I've created variables for the connection, the server, the database and also tried a table variable as well. I set them all not to export the value.
When I import the solution, I add the new server, database and table. But once it's imported, I can see the server and database have changed, but the table still points to the old table reference and doesn't use the new one during import.
Is there a workaround to make this work, or am I doing something wrong.
I even tried starting again with a new unmanaged solution, creating a new app, connections and variables, adding the SQL datasource to the app using the new variables, and exporting as a managed solution. But still the issue persists. The imported solution holds onto the old table reference and doesn't using the new one that's added during import.
