Share via

SQL Data Import wizard failed to process in Sql Server 2008 express

  • Article
  • 08/08/2013

Question

Thursday, August 8, 2013 6:59 AM

I got this message at the time of running this wizard after Click on Ok then close wizard.

TITLE: Microsoft SQL Server

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

ADDITIONAL INFORMATION:

General access denied error

BUTTONS:

OK

When i did follow this link after opening of a web page that shows following details on webpage 

Details
ID: UncaughtException                                             
Source: Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR                                             
   
We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.

Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.

So please reply this ASAP.

Regards,

Atul Sharma

All replies (4)

Thursday, August 8, 2013 7:52 AM

Express edition doesnt support SSIS and Import/export wizard functionality.The same is supported in Enterprise and standard.

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Thursday, August 15, 2013 12:23 PM

Hi Atul,

According to the error information, this issue can occur if Integration Service log on account doesn’t has permission to access the file.

Firstly, SQL Server 2008 Express supports the Import/Export Wizard feature. We need to choose a Data source from which to copy data when using SQL Server Import and Export Wizard to import data. Therefore, please confirm the permission whether Integration Service log on account can visit the folder containing the Data source. If the permission is insufficient, please refer to the following steps:

1.    Find the folder containing the Data source.
2.    Right click the folder, switch to the Security tab, and click “Edit”
3.    Click “Add”, then add the SQL Server account and check the “Read” and “Write” permission.

Then, use the Import/Export Wizard again to see whether the issue still exists.

Reference:
http://technet.microsoft.com/en-us/library/ms165636(v=sql.100).aspx

If you have any questions, please feel free to let me know.

Regards,
Heidi Duan

 

Thursday, August 15, 2013 1:52 PM

Hi Atul,

According to the error information, this issue can occur if Integration Service log on account doesn’t has permission to access the file.

Firstly, SQL Server 2008 Express supports the Import/Export Wizard feature.

Reference:
http://technet.microsoft.com/en-us/library/ms165636(v=sql.100).aspx

 

Hello Heidi,

SQL server 2005 express does not support Import/export wizard feature and that can be confirmed from link provided  by you( i was thinking about 2005 express).Thanks for pointing out that feature is supported in SQL 2008 express.

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

Friday, August 23, 2013 11:04 AM

Hi Heidi,

Thank you for reply,  this error occur when i click to open window of Import/export data wizard than it give that error. so i am not unable to go next window then exit with error message.

Regards,

Atul Sharma