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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics