September 14, 2007 at 9:20 am
We have a SSIS Package job sheduled to run daily on Cluster SQl Server. Somehow the package is running fine most of the times, but it some times failing with the following error:
Executed as user: Domain\User. The package could not be loaded. The step failed.
Domain\User has admin rights, but still it is failing.
Can anyone help with this issue.
September 18, 2007 at 4:55 am
There is an error in the package. Any errors occurring during the process do not get passed back to agent. You have to enable logging in the package and view the log files.
Menu > SSIS > Logging
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
September 19, 2007 at 2:12 pm
The job is run successfully most of the times, but it fails some times. There is already log created for that package but it doesn't get created as the package didn't even load?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply