Package Configuration Wizard Error
I am attempting to create an XML Configuration file and I am recieving the following error once I click finish in the wizard:
Could not complete wizard actions.
Additional Information:Could notgenerate 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)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Wizards.ConfigurationWizardPages.ConfigurationWizardSR&EvtID=CouldNotGenerateConfigurationFile&LinkId=20476
------------------------------Program Location:
at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration) at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.OnFinish(CancelEventArgs e)
===================================
Failure exporting configuration file.(eFreedomAS)
------------------------------Program Location:
at Microsoft.SqlServer.Dts.Runtime.Package.ExportConfigurationFile(String str) at Microsoft.DataTransformationServices.Wizards.ConfigurationWizardForm.GenerateXmlConfigurationFile(DesignTimeConfiguration designTimeConfiguration)
Name:eFreedomAS2
Type:Configuration File
New configuration file will be created.
File name:C:\abc.xml
Properties:\Package.Variables[User::SourcePath].Properties[Value]\Package.Variables[User::SourcePath].Properties[Name]\Package.Variables[User::Packages].Properties[Value]\Package.Variables[User::Packages].Properties[Name]\Package.Variables[User::PackageDefNumber].Properties[Value]\Package.Variables[User::PackageDefNumber].Properties[Name]\Package.Variables[User::Directory].Properties[Value]\Package.Variables[User::Directory].Properties[Name]\Package.Variables[User::DestinationPath].Properties[Value]\Package.Variables[User::DestinationPath].Properties[Name]\Package.Connections[ViewHelpTopicDef].Properties[Name]\Package.Connections[ViewHelpTopicDef].Properties[ConnectionString]\Package.Connections[ViewDef].Properties[Name]\Package.Connections[ViewDef].Properties[ConnectionString]\Package.Connections[ValidationTestDef].Properties[Name]\Package.Connections[ValidationTestDef].Properties[ConnectionString]\Package.Connections[ValidationRulePackageDef].Properties[Name]\Package.Connections[ValidationRulePackageDef].Properties[ConnectionString]\Package.Connections[ValidationRuleFileDef].Properties[Name]\Package.Connections[ValidationRuleFileDef].Properties[ConnectionString]\Package.Connections[ValidationRuleDef].Properties[Name]\Package.Connections[ValidationRuleDef].Properties[ConnectionString]\Package.Connections[ValidationMessageFileDef].Properties[Name]\Package.Connections[ValidationMessageFileDef].Properties[ConnectionString]\Package.Connections[ValidationMessageDef].Properties[Name]\Package.Connections[ValidationMessageDef].Properties[ConnectionString]\Package.Connections[ValidationIdentifierDependency].Properties[Name]\Package.Connections[ValidationIdentifierDependency].Properties[ConnectionString]\Package.Connections[ValidationCalcGraphEdge].Properties[Name]\Package.Connections[ValidationCalcGraphEdge].Properties[ConnectionString]\Package.Connections[UserGroupFeatureDef].Properties[Name]\Package.Connections[UserGroupFeatureDef].Properties[ConnectionString]\Package.Connections[UserGroupFeature].Properties[Name]\Package.Connections[UserGroupFeature].Properties[ConnectionString]\Package.Connections[UserGroupDef].Properties[Name]\Package.Connections[UserGroupDef].Properties[ConnectionString]\Package.Connections[UserGroup].Properties[Name]\Package.Connections[UserGroup].Properties[ConnectionString]\Package.Connections[TableDef].Properties[Name]\Package.Connections[TableDef].Properties[ConnectionString]\Package.Connections[Source].Properties[UserName]\Package.Connections[Source].Properties[ServerName]\Package.Connections[Source].Properties[Password]\Package.Connections[Source].Properties[Name]\Package.Connections[Source].Properties[InitialCatalog]\Package.Connections[Source].Properties[ConnectionString]\Package.Connections[SelectListItemDef].Properties[Name]\Package.Connections[SelectListItemDef].Properties[ConnectionString]\Package.Connections[SelectListDef].Properties[Name]\Package.Connections[SelectListDef].Properties[ConnectionString]\Package.Connections[ScriptAssemblyDef].Properties[Name]\Package.Connections[ScriptAssemblyDef].Properties[ConnectionString]\Package.Connections[PrintedPageFormulaScriptDef].Properties[Name]\Package.Connections[PrintedPageFormulaScriptDef].Properties[ConnectionString]\Package.Connections[PageDef].Properties[Name]\Package.Connections[PageDef].Properties[ConnectionString]\Package.Connections[PageCalcPathSubPath].Properties[Name]\Package.Connections[PageCalcPathSubPath].Properties[ConnectionString]\Package.Connections[PageCalcPath].Properties[Name]\Package.Connections[PageCalcPath].Properties[ConnectionString]\Package.Connections[PackageLinkDef].Properties[Name]\Package.Connections[PackageLinkDef].Properties[ConnectionString]\Package.Connections[PackageImportTypeDef].Properties[Name]\Package.Connections[PackageImportTypeDef].Properties[ConnectionString]\Package.Connections[PackageIdentifierGroupDef].Properties[Name]\Package.Connections[PackageIdentifierGroupDef].Properties[ConnectionString]\Package.Connections[PackageIdentifierDef].Properties[Name]\Package.Connections[PackageIdentifierDef].Properties[ConnectionString]\Package.Connections[PackageExportTypeDef].Properties[Name]\Package.Connections[PackageExportTypeDef].Properties[ConnectionString]\Package.Connections[PackageDef].Properties[Name]\Package.Connections[PackageDef].Properties[ConnectionString]\Package.Connections[PackageDataItemTextDef].Properties[Name]\Package.Connections[PackageDataItemTextDef].Properties[ConnectionString]\Package.Connections[OnlinePagePrintedPageDef].Properties[Name]\Package.Connections[OnlinePagePrintedPageDef].Properties[ConnectionString]\Package.Connections[OnlinePageDefDependency].Properties[Name]\Package.Connections[OnlinePageDefDependency].Properties[ConnectionString]\Package.Connections[OnlinePageDef].Properties[Name]\Package.Connections[OnlinePageDef].Properties[ConnectionString]\Package.Connections[MaterialityToleranceDef].Properties[Name]\Package.Connections[MaterialityToleranceDef].Properties[ConnectionString]\Package.Connections[LineDef].Properties[Name]\Package.Connections[LineDef].Properties[ConnectionString]\Package.Connections[ImportTypeDef].Properties[Name]\Package.Connections[ImportTypeDef].Properties[ConnectionString]\Package.Connections[ImportDef].Properties[Name]\Package.Connections[ImportDef].Properties[ConnectionString]\Package.Connections[IdentifierStateDef].Properties[Name]\Package.Connections[IdentifierStateDef].Properties[ConnectionString]\Package.Connections[IdentifierRelatedDef].Properties[Name]\Package.Connections[IdentifierRelatedDef].Properties[ConnectionString]\Package.Connections[IdentifierPrintReferenceDef].Properties[Name]\Package.Connections[IdentifierPrintReferenceDef].Properties[ConnectionString]\Package.Connections[IdentifierGroupUserGroupFeatureDef].Properties[Name]\Package.Connections[IdentifierGroupUserGroupFeatureDef].Properties[ConnectionString]\Package.Connections[IdentifierGroupUserGroupFeature].Properties[Name]\Package.Connections[IdentifierGroupUserGroupFeature].Properties[ConnectionString]\Package.Connections[IdentifierGroupIdentifierDef].Properties[Name]\Package.Connections[IdentifierGroupIdentifierDef].Properties[ConnectionString]\Package.Connections[IdentifierGroupIdentifier].Properties[Name]\Package.Connections[IdentifierGroupIdentifier].Properties[ConnectionString]\Package.Connections[IdentifierGroupDef].Properties[Name]\Package.Connections[IdentifierGroupDef].Properties[ConnectionString]\Package.Connections[IdentifierGroup].Properties[Name]\Package.Connections[IdentifierGroup].Properties[ConnectionString]\Package.Connections[IdentifierDef].Properties[Name]\Package.Connections[IdentifierDef].Properties[ConnectionString]\Package.Connections[IdentifierDataItemTextDef].Properties[Name]\Package.Connections[IdentifierDataItemTextDef].Properties[ConnectionString]\Package.Connections[FormulaScriptDef].Properties[Name]\Package.Connections[FormulaScriptDef].Properties[ConnectionString]\Package.Connections[FormulaDef].Properties[Name]\Package.Connections[FormulaDef].Properties[ConnectionString]\Package.Connections[FeatureGroupFeatureDef].Properties[Name]\Package.Connections[FeatureGroupFeatureDef].Properties[ConnectionString]\Package.Connections[FeatureGroupDef].Properties[Name]\Package.Connections[FeatureGroupDef].Properties[ConnectionString]\Package.Connections[FeatureDef].Properties[Name]\Package.Connections[FeatureDef].Properties[ConnectionString]\Package.Connections[ExportTypeRelatedDef].Properties[Name]\Package.Connections[ExportTypeRelatedDef].Properties[ConnectionString]\Package.Connections[ExportTypeFormulaScriptDef].Properties[Name]\Package.Connections[ExportTypeFormulaScriptDef].Properties[ConnectionString]\Package.Connections[ExportTypeExportDef].Properties[Name]\Package.Connections[ExportTypeExportDef].Properties[ConnectionString]\Package.Connections[ExportTypeDef].Properties[Name]\Package.Connections[ExportTypeDef].Properties[ConnectionString]\Package.Connections[ExportTypeBlobTypeDef].Properties[Name]\Package.Connections[ExportTypeBlobTypeDef].Properties[ConnectionString]\Package.Connections[ExportFormulaScriptDef].Properties[Name]\Package.Connections[ExportFormulaScriptDef].Properties[ConnectionString]\Package.Connections[ExportDef].Properties[Name]\Package.Connections[ExportDef].Properties[ConnectionString]\Package.Connections[ColumnHeaderDef].Properties[Name]\Package.Connections[ColumnHeaderDef].Properties[ConnectionString]\Package.Connections[ColumnDef].Properties[Name]\Package.Connections[ColumnDef].Properties[ConnectionString]\Package.Connections[CellTypeFileTypeDef].Properties[Name]\Package.Connections[CellTypeFileTypeDef].Properties[ConnectionString]\Package.Connections[CellTypeDef].Properties[Name]\Package.Connections[CellTypeDef].Properties[ConnectionString]\Package.Connections[CellRangeDef].Properties[Name]\Package.Connections[CellRangeDef].Properties[ConnectionString]\Package.Connections[CellRangeCellDef].Properties[Name]\Package.Connections[CellRangeCellDef].Properties[ConnectionString]\Package.Connections[CellOverrideDef].Properties[Name]\Package.Connections[CellOverrideDef].Properties[ConnectionString]\Package.Connections[CellDef].Properties[Name]\Package.Connections[CellDef].Properties[ConnectionString]\Package.Connections[CategoryDef].Properties[Name]\Package.Connections[CategoryDef].Properties[ConnectionString]\Package.Connections[CalcPathSubPath].Properties[Name]\Package.Connections[CalcPathSubPath].Properties[ConnectionString]\Package.Connections[CalcPath].Properties[Name]\Package.Connections[CalcPath].Properties[ConnectionString]\Package.Connections[CalcGraphEdge].Properties[Name]\Package.Connections[CalcGraphEdge].Properties[ConnectionString]\Package.Connections[AreaDef].Properties[Name]\Package.Connections[AreaDef].Properties[ConnectionString]
August 9th, 2006 11:26am
Found the issue myself. One of the variables I had unintentionally set for the package configuration was of type Object. Rightfully so, you are unable to save a variable of type object to be saved in an xml configuration file.
Free Windows Admin Tool Kit Click here and download it now
August 9th, 2006 6:30pm
So how did u deal with that?
Did you change Variable Type from Object to something else pls let me know
Thanks T T
April 8th, 2008 11:50pm
issares wrote:
So how did u deal with that?
Did you change Variable Type from Object to something else pls let me know
Thanks T T
if i'm not mistaken, JAdams2006 means that an object variable cannot be assigned a value through a configuration file. this makes sense if you think about it. a system.object type cannot be put in a configuration file because configuration files are not .net aware.
hth
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2008 1:14am
Glad to see that MSFT took the extra time to disallow selecting variables that aren't allowed to be selected. Further, I'm glad that the error message provided clearly and consisely points to the problem.
May 18th, 2012 2:15pm


