Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


An Introduction to Integration Services log providers


An Introduction to Integration Services log providers

Author
Message
Stan Kulp-439977
Stan Kulp-439977
SSC Veteran
SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)

Group: General Forum Members
Points: 260 Visits: 1095
Comments posted to this topic are about the item An Introduction to Integration Services log providers
prasannadns
prasannadns
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 32
Good intro about logging in SSIS. Keep them coming. Your articles are very good for beginners like me in SSIS.
Thanks.
sabotta
sabotta
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 124
For more information about events logged by SSIS packages the Integration Services Service, see these BOL topics, Understanding Events Logged by an Integration Services Package, Understanding Events Logged by the Integration Services Service

You can use the SSIS Log Analyzer to analyze complex and verbose SSIS logs. For a demo, see the SSIS Log Analyzer (SQL Server Video).
Stan Kulp-439977
Stan Kulp-439977
SSC Veteran
SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)

Group: General Forum Members
Points: 260 Visits: 1095
Thanks!
Misha_SQL
Misha_SQL
SSChasing Mays
SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)SSChasing Mays (614 reputation)

Group: General Forum Members
Points: 614 Visits: 986
I have always been using either SQL Server or text file logging with SSIS, since they are easy to review. Could you comment on potential usages (advantages/disadvantages) of some of the other types of logging, which seem a bit more "exotic", such as trace file or XML?

Thank you for the article!



Stan Kulp-439977
Stan Kulp-439977
SSC Veteran
SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)

Group: General Forum Members
Points: 260 Visits: 1095
I decided to explore SSIS logging because I wanted to be able to insert custom data into the logging stream, specifically the date/time stamp of data files processed by SSIS packages.

One of the criticisms that I had received from my previous article

Copy-and-Paste SSIS Execution Monitoring with Failure-Alert Email

was that SSIS logging provided everything already and I should learn it rather than reinvent the wheel.

All five of the SSIS logging outputs contain the same exact data. My guess is that there are custom clients that can read and display each type of log output. For all practical purposes it doesn't matter which one you use. The text file is the easiest to use because you can just open it in notepad. Another approach would be to write an SSRS report to view the sys.sysssislog table.

I still don't think you can store the file timestamp in the SSIS logging stream, which is very useful information if there is a possibility that your job might reprocess a file from the previous day if a new one hasn't replaced it.
alen teplitsky
alen teplitsky
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1595 Visits: 4621
will this run when a SSIS package runs as a job?

at the start of every year i try to increase the amount of logging and reporting we have to make life easier
Stan Kulp-439977
Stan Kulp-439977
SSC Veteran
SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)SSC Veteran (260 reputation)

Group: General Forum Members
Points: 260 Visits: 1095
The whole idea is that the logging occurs whenever the package runs.

The only catch is you have to add logging to each SSIS package individually.

Only the packages that you have added it to will log their execution.

Crazy, I know, but that goes along with the fact that you can't write global functions that all your SSIS packages can use.

Each of your SSIS packages is an island unto itself.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search