SSIS Package -Could not load package because of error 0xC0014062

1

I am getting below error on Window server 2008.

I am using 32 bit DTexec from C:\"Program Files (x86)"\"Microsoft SQL Server"\90\DTS\Binn\dtexec.exe

Could not load package because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.). The SQL statement that was issued has failed.

sql
sql-server
ssis
asked on Stack Overflow Oct 6, 2014 by Sheetal

3 Answers

1

To get more information about this error, do the following:

  1. Using Microsoft SQL Server Management Studio
  2. Go to SQL Server Agent -> Jobs -> Right-click on the particular one that you has the issue, and click Properties.
  3. Go to Steps -> Choose the step -> Click Edit -> Under Advanced check: Include step output in history.
  4. Retry to run the Job on more time.
  5. Right click on the Job and choose History that will give you more information about the error.

Some solutions:

  • A missing "/" at the package of the Job, see the following screenshot: enter image description here

  • Sometimes the SQL Server needs SSIS to be installed, so make sure you have it if you don't.

answered on Stack Overflow Oct 29, 2014 by Husam Hilal
0

If you will load a ssis package from a sql server, under a proxy account, be sure to grant to that user db_ssisoperator on msdb database.

answered on Stack Overflow Feb 18, 2016 by Maday
0

If it's SQL2016...

  1. click on job
  2. choose properties
  3. Steps-->Edit-->Execution Options
  4. Check use 32-bit runtime
answered on Stack Overflow Nov 28, 2018 by Karl T

User contributions licensed under CC BY-SA 3.0