Thursday , April 25 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Could not load package “packet_name” because of error 0xC0014062

Ekrem Önsoy December 26, 2018 MSSQL

ERROR:

Could not load package “packet name” because of error 0xC0014062.Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E4D (Login failed for user ‘login_name’.). The SQL statement that was issued has failed.

EXPLANATION:

You may experience such an error when you try to load a SSIS package.

SOLUTION:

Make sure that the user (the user in the “Login failed for user” section) has Login and sufficient rights on that server.

About Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.