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.
To get more information about this error, do the following:
Some solutions:
A missing "/" at the package of the Job, see the following screenshot:
Sometimes the SQL Server needs SSIS to be installed, so make sure you have it if you don't.
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.
If it's SQL2016...
User contributions licensed under CC BY-SA 3.0