SQL server Import and Export Wizard Error

Question

SQL server Import and Export Wizard Error

tomas.dobremysl

SSC-Addicted

Points: 430
More actions
May 28, 2014 at 11:37 pm

#308565

Hello, I have problem with import and export wizard. There are advabnced information:
===================================
This wizard will close because it encountered the following error: (Microsoft SQL Server)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.5500.0&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476
===================================
Sekce DbProviderFactories se může v konfiguračním souboru objevit pouze jednou. (System.Configuration)
------------------------------
Program Location:
v System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
v System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
v System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
v System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
v System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
v System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
v System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
v System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName)
v System.Configuration.ConfigurationManager.GetSection(String sectionName)
v System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName)
v System.Data.Common.DbProviderFactories.Initialize()
v System.Data.Common.DbProviderFactories.GetFactoryClasses()
v Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.AddAdoNetProviders()
v Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean fSources, WizardInputs wizardInputs)
v Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
v Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
v Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
v Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)
Can anybody help me? Thank you,Tomas...:-)

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 1

Can you tell us a little bit more about what you where doing, at which step this happened, server versions, user permission and so on?:cool:

tomas.dobremysl SSC-Addicted Points: 430 More actions · Answer 2

Hi, sorry 🙂

I am only trying to import data into SQL server. QSL versions which I am using is not important, because it looks as local problem, but I have SQL 2000, 2005 and 2008. This problem apears when I right clik on DB and choose Import data... :satisfied:

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 3

Versions do matter here, seen this when trying to do an imp/exp from 2008 in SSMS 2005.

Could you please provide the information asked for in the previous post!

😎

tomas.dobremysl SSC-Addicted Points: 430 More actions · Answer 4

I am trying to import local excel table into SQL 2000 by these steps:

Right click on DB, choose Import data and when I click Next from Welcome window, then the error message popup and wizard is closed after clicking on OK in error message. Therefore I thing that it is problem with local instalation of MSSMS...

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 5

Are you using SSMS to import into SQL Server 2000?;-) The fault would be when the IEW tries to enumerate objects in the SQL 2000 database instance, doesn't get what it wants and then throws all of its toys out of the pram.

Have you tried this from Enterprise Manager (2000)?

😎

You might want to check this as an alternative.

tomas.dobremysl SSC-Addicted Points: 430 More actions · Answer 6

Yes, by enterprice manager it works. SSMS is not working when I try to Import data into 2000, 2005 and also 2008. I also try to repair instalation of SSMS, but without success. What I like to find is, where is saved DbProviderFactories and also System.Configuration (this is in error message described in czech lenguage: Sekcion DbProviderFactories can be saved in configuration file only once. (System.Configuration)). If I found it I can try to fix this trouble.

tomas.dobremysl SSC-Addicted Points: 430 More actions · Answer 7

Problem solved by un-install and install SSMS - files were probably corrupted by instalation of Visual Studio 2012. After re-instaling it works fine.. Thank you.

bharani.sbk SSC Journeyman Points: 79 More actions · Answer 8

Even i have the same problem,I was trying to import my data from Azure Blob storage to Azure SQL database using SSMS,but I got the error message as "Parameter count Mismatch(mscorlib)".Any solutions for this.