I have been trying now for hours to get basic logging working in SQL2005 and have had zero luck.
I have a very simple package. It consists of one task: abckup a user database.
I create a Connection Manager that isa file connection manager. I choose the location of the file and choose "Create File". The directory exists. I'm an administrator on the box in question.
In the package I choose "SSIS", go to Logging. I choose the component I want to log for. I add a logging provider for text files and choose the appropriate connection manager.
On the details pane, I pick every category, and for each category I pick every event. So regardless, there should be SOMETHING logged. I choose "Save" and give a name for the xml file. I choose okay.
I then choose "Save All".
I run the package. Nothing is logged. The file never gets created.
I haev seen dozens of people having the asme issue and their questions seem to go unanswered. This should be the easiest thing to do, so why is this so difficult to get to work properly?
Any help would be appreciated.A. M. Robinson
View Complete Post