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 objectIn this situation, you have no way to know which columns are missing.
Service pack informationTo fix this problem, get Service Pack 3 for SQL Server 2012.
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
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3112704 - Last Review: Nov 16, 2016 - Revision: 1
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