I'm trying to add a simple configuration to a SSIS package, of type SQL Server, so stored in a table. At the end of the wizard, when it goes to try and write a new row to the nominated table to store the configuration it fails with the error:
TITLE: Microsoft Visual Studio
Could not complete wizard actions.
Cannot retrieve configuration table schema. (Microsoft.DataTransformationServices.Wizards)
I can't seem to resolve this. The configuration connection has full permissions on the table, and it sees it and can read from it as it reports there is no current data for the filter I provide. It just wont write to it. A Google search of the error message above in quotes returns literally no hits! Any suggestions?
© Stack Overflow or respective owner