FIX: Missing columns aren't specified in the error message when you import data by using the Import and Export Wizard

Symptoms
Assume that you use ADO.NET Connection Manager to import data in Microsoft SQL Server 2012 or 2016. However, if the columns that are expected by the Import and Export Wizard are missing, the import operation fails, and you receive the following error message:

Object reference not set to an instance of an object

In this situation, you have no way to know which columns are missing.
Resolution

Service pack information

To fix this problem, get Service Pack 3 for SQL Server 2012.
For more information about SQL Server 2012 Service Pack 3 (SP3), see bugs that are fixed in SQL Server 2012 Service Pack 3.

This issue was also fixed in the SQL Server 2016 Service Pack 1 (SP1). See the SQL Server 2016 build versions.

Cumulative update information

Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Propiedades

Id. de artículo: 3112704 - Última revisión: 11/16/2016 09:14:00 - Revisión: 2.0

Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core, Microsoft SQL Server 2016 Standard

  • kbfix kbqfe kbexpertiseadvanced kbsurveynew KB3112704
Comentarios