Receiving the following error in SQL Server Integration Services?
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL 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.). Make sure you are accessing a local server via Windows security.".
Here's the likely reason: You are using a SQL Server Destination adapter, but the machine running the SSIS process is not the same as your SQL Server destination.
SQL Server Destination Adapters are supposedly more performant than OLE DB's, but one big caveat is that the SSIS and Destination must be the same server. To fix, you'll need to change the destination adapter to an OLE DB Destination adapter.