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.
Propriedades

ID do Artigo: 3112704 - Última Revisão: 16 de nov de 2016 - Revisão: 1

Comentários