How to Log Errors/Warning in SSIS
Its easy to log execution details, errors,warning in SSIS. In order to log execution events.
Go to SSIS Menu
Click on Logging as shown in the above.
There are multiple options to log the events in SSIS. Different Options are
1) SSIS Log Provider for SQL Server Profiler : Log Events will be saved in trace files. The Log can be opened using SQL Server profiler. Later it can be saved into SQL Server database using the method fn_trace_gettable
2) SSIS Log Provider for XML files : Log Events will be saved in XML Files. This XML file we can save into SQL Server later using the Rowset functions (OPENXML).
3) SSIS Log provider for SQL Server : Log Events will be saved in SQL Server. SQL Server creates an internal table.
The log details will be stored in sysssislog table. The message column stores the error message.
4) Sqlserver log provider for Windows Event Log : Log Events will be saved in Windows Event Log.
5)Sqlserver log provider for Text files : Log events will be saved in text files.
There are two tabs to configure the logs in ssis.
1) Providers and Logs :
In this we can select the log providers to save the log events include errors,warnings.
2) Details : In this tab we can select list of events that required for logging.
4 comments:
Hello,firstly I would like to thank you for such an informative article and also would like to ask you that do you have some more articles like this on the wide use of SSIS Postgresql Write.
I think SSIS is the best tool to provide solution to very complex IT problems.
SSIS Postgresql Write
I feel SSIS is the most useful and understating aspect of most complex problems and to look for more and more solutions about this.
SSIS Postgresql Read
I feel SSIS is the best and most useful tool or rather software which can ease out the most complex and large no.of volumnious database operations anyhow.This will eventually supplement solutions for many problems.
SSIS Postgresql Write
Post a Comment