Log Providers
Logging is an important concept, especially when it comes to auditing and trouble
shooting problems that occur at run time.
SSIS has built-in log providers that can be used to implement logging in packages,
tasks, containers, etc. Logging can capture run time information about a package,
such as the user who ran the package and the start time and stop time of the package
execution. Adding logging support to a package requires a log provider as well
as a location for the log. A log provider specifies the format for the logged data.
Following are the types of log providers:
Text file log provider, log will be in ASCII format in a CSV file.
SQL Server Profiler log provider, provides a log file with extension .trc.
SQL Server log provider writes entries to sysdtslg90 table in SQL
2005 database.
Windows Event log provider, events log in the local computer.
XML file log provider, generates a log file with extension .xml.
??? ??? ??? ??? ???
SSIS Basics
[ 26 ]
Debugging and Diagnostic Features
It is possible that a package has a bug, and in order to look into where the problem
is, you need debugging features. SSIS has built-in debugging support in the form of
Breakpoints window, Locals Window, Watch window, and the Call Stack window.
These function similar to what one finds in the other Microsoft product like Visual
Basic. Additionally, there are diagnostic windows like Error List window, Output
window, and Task List windows.
Pages:
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45