Hi there all...
We've just started using SSIS packages, and everything seems to be going ok.
I've recently set up a couple of jobs which just run an SSIS package every 5 minutes to collect data.These run fine 90% of the time, but intermittantly produce an error.
When using a SSIS task in the job it simply reported"Could not load Package."
I have changed these to use DTExec as I heard it gave more verbose execution results, and now I get an error like"Executed as user: NZ\SQLAdmin. Microsoft (R) SQL Server Execute Package UtilityÃÂ Version 9.00.1399.06 for 32-bitÃÂ Copyright (C) Microsoft Corp 1984-2005. All rights reserved.ÃÂ ÃÂ ÃÂ Started:ÃÂ 8:25:00 a.m.ÃÂ Could not load package "\MSDB\RadiusBilling\Get_RADIUS_AuthLog" because of error 0x80040E37.ÃÂ Description: Table/view either does not exist or contains errors.ÃÂ Source: Microsoft SQL Native ClientÃÂ Started:ÃÂ 8:25:00 a.m.ÃÂ Finished: 8:25:00 a.m.ÃÂ Elapsed:ÃÂ 0.047 seconds.ÃÂ Process Exit Code 5.ÃÂ The step failed."
So far I have not been able to find anyone else with similar errors.Whenever the package executes it seems to run fine, so this seems to be an error just getting the package to execute in the first place, and as I said it only happens internittantly.
The packages talk to a SQL2005 server using windows authentication (which I assume is inherited from the SQLAgent service user), as well as a MySQL
View Complete Post