SSIS Configuration error: Cannot retrieve configuration table schema

Posted by Glenn M on Stack Overflow See other posts from Stack Overflow or by Glenn M
Published on 2010-04-15T22:44:30Z Indexed on 2010/04/15 23:03 UTC
Read the original article Hit count: 898

Filed under:

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

Related posts about ssis

Related posts about configuration