You know, SQL Server is really starting to piss me off. Either it or my ignorance of it.
I run a job, and it fails. If I double-click on 'Failed', it tells me to view the history log for details. So I do, and the message is, 'The package execution failed. The step failed.'
Reeeal useful. I have to execute the package in that step (found in the log) manually, using dtexecui.exe, so that I can get why the package failed.
Two major irritations:
- Why do I have to go to three or four different places just to get an error message that's useful?
- Why do I keep clicking on that 'Failed' link, when it never tells me anything useful?