|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Thursday, June 06, 2013 1:51 PM
Points: 32,
Visits: 124
|
|
Hello everyone !!
I am planning to implement SSIS logging . I have tried both the log to a file and log to the database . I am having a hard time choosing among the two.
I would like to get some advice from some of the more experienced SSIS developers if any one of them would be better in the long run?
I also intend to set up an email notification on failed tasks and send the log details via email.
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: 2 days ago @ 4:25 AM
Points: 117,
Visits: 473
|
|
I've done both and found tables to be easier to get the info you need out such as timings of steps etc. However i have generally found that support/help teams prefer text file logging. In my previous place we used tables then moved to text files because the help guys preferred it - they never really got to grips with querying a table when things went wrong (they were a bunch of numpties tho).
So my opinion is it depends on who will support your load
Mack
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Thursday, June 13, 2013 3:01 PM
Points: 121,
Visits: 420
|
|
| It may be coincidence, but I've never worked for a company that uses text files for logging or auditing - always table driven. Personally, I'd never use text files for similar reasons that I'm not a fan of using .raw files. Everything should use tables IMO. The person above makes a good case for the possibility of text files, but most DW troubleshooting is done by the developers and I just couldn't imagine using text files vs the ease of querying a table. Kimball has a nice auditing framework that provides the basics - for free. I've seen a lot of companies use this as their base and then expand upon it.
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Today @ 12:22 PM
Points: 3,017,
Visits: 4,471
|
|
+1 ... I would go for a table too. Much more flexible.
_____________________________________ Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Thursday, June 06, 2013 1:51 PM
Points: 32,
Visits: 124
|
|
Thank you guys ! I would start logging with a table.
|
|
|
|