SQL Server Destination error “0x80040E14 “

Limitation of the SQL Server Destination Object

"If you attempt to use the SQL Server destination to bulk load data into a remote SQL Server database, you may see an error message similar to the following: "An OLE DB record is available. Source: "Microsoft SQL Server Native Client" Hresult: 0x80040E14 Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ' could not be opened. Operating system error code 2 (The system cannot find the file specified.)….

For loading data into SQL Server, you should consider using the SQL Server destination instead of the OLE DB destination.  ." 


Let's share thisShare on Facebook
Tweet about this on Twitter
Share on LinkedIn