SQL Server Destination remote server error
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:
An OLE DB record is available. Source: “Microsoft SQL Server Native Client
10.0” Hresult: 0x80040E14 Description: “Could not bulk load
because SSIS file mapping object ‘GlobalDTSQLIMPORT ‘ could not be opened. Operating
system error code 5(Access is denied.). Make sure you are accessing a local
server via Windows security.”.
Users who execute packages that include SQL Server
destination require the “Create global objects” permission. You can
grant this permission to users by using the Local Security Policy tool opened
from the Administrative Tools menu. If you receive an error message when
executing a package that uses the SQL Server destination, make sure that the
account running the package has the “Create global objects”
If you are not allowed to change the permission, you should change
the SQL Server destination to OLE DB Destination.