I spent an hour today quietly cursing while I attempted to create a new configuration file for a SSIS package. The error message was a classic non-helpful message…
“Could not generate the configuration file. (Microsoft.Data.TransformationServices.Wizard)
Technical Details:
===================================
Could not complete wizard actions. (Microsoft Visual Studio)
===================================
Could not generate the configuration file. (Microsoft.DataTransformationServices.Wizards)”
I began with the usual suspects. The path was not read only, the file had been checked out for editing, no other path worked. Finally I left off two of the variables I was attempting to put in the configuration file, et voila, it worked.
The variables in question were object type variables. Had I thought about it for a few seconds, I would have realized that configuration files are not .NET aware. Moreover the generic system.object type could be almost anything, and configuration files really are limited to the more specific data types (e.g. strings, integers and the like).
It would be nice if the error message was a tad more informative however.