Backup Database Task, Fails Silently
My package fails without enough information to determine why. How do I get more verbose output to debug?
This is all I get in visual studio, the sql agent task history is no better:
"Task failed: Backup TLogs"
July 2nd, 2011 6:49pm
You can enable logging by setting up a Log Provided path (typicaly a text file stored on your disk drive) in the SSIS package and have it log all types of events (information/progress/error). To accomplish this, right click on the control flow of the
package and choose "Logging". The wizard is pretty intutive.
Run the package after setting up the logging and once it fails (as expected), browse through the log generated for that execution and see if you can spot something fishy.
Hope this helps!
Cheers!!
Muqadder.
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 9:23pm


