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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics