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.




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |