SQL Server Destination remote server 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 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.”.

Solution

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” permission.

If you are not allowed to change the permission, you should change the SQL Server destination to OLE DB Destination.

]]>

Leave a comment

Your email address will not be published.