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

 http://msdn.microsoft.com/en-us/library/ms141095.aspx

Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn