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: 939
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?
Glenn
© Stack Overflow or respective owner
