I've created the table [SSIS Configurations] and have added a dummy row to this with "XYZ" in the filter name.
When I use the package configuration wizard I can see that offered as a filter - so I know my connection is seeing the server ok.
The problem I get is when I get through to "Finish" and insert the configuration to the table - I get this error message and I can't find any help on it:
Cannot insert configuration information into the configuration table. (Microsoft.DataTransformationServices.Wizards)
Could not complete wizard actions.
I'm connecting as system administrator and am just foxed as to why it won't insert ... Anyone got any pointers?
Many thanks
Matt
have you used SQL Profiler to watch what is being sent to the server?|||*bump*
I am getting this error too.
Any ideas? Nothing odd in profiler.
|||
that is weird. If you are choosing a row that already exists in the configuration table; I think the wizard prompts you whether you wan to re-use the exiting row or not...do you see that prompt? what are you selecting?
|||I've resolved my issue.
It was to do with a property value (an SQL string) that was too long to fit in the default configuration table data column (254 characters.)
I have moved to using an external xml file instead for the SQL statements.
I also tried making the column larger, but ultimately I think the more appropriate option for us is going to be external xml files.
No comments:
Post a Comment