April 17, 2009 at 7:49 am
I have created a SQLAgent job calling a SSIS package!
I keep getting the following error:
Message
Executed as user: UK\SQLAdmin. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 14:46:22 Could not load package "\AMS\Get RDIR file via FTP" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed. Source: Started: 14:46:22 Finished: 14:46:38 Elapsed: 15.907 seconds. The package could not be loaded. The step failed.
April 17, 2009 at 10:13 am
Did u deploy your package to the right folder?
Open a connection to SSIS thru SQL Server Management studio and verify its path.
May 26, 2021 at 5:40 am
i found the problem when i create a maintenance plan and it dosnt work!!!
go to the agen jobs and right click on the job that you want to rapair it(for me was the name of maintenance plan that i created) then go to the steps (for example for me was subplan_1) and edite the step change the user to sa and set password it will be fixed!!!
May 26, 2021 at 5:54 am
this problem probably is for disabling the windows authentication
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply