Logging In SSIS
Ma Gurudeva
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Refer the Source Video: SSIS:Logging
Right click in Package - Logging
Sql Task
Containers: Flexibility to choose a task
( allows task wise track error messages.)
Logs Details(Event wise error messages: On Error, OnPostExecute,OnPreExecute)
Provider Type:
SSIS log Provider for windows
SSIS log Provider for Text files (.txt)
SSIS log Provider for XML files (.xml)
SSIS log Provider for SQL Server
SSIS log Provider for SQL Server Profiler (.trc) {Only for 32bit, change in right clicking on Project Explorer,,)
Mostly used:Windows & SQL Server one
Windows see in Windows Event Viewer:
Select * from SYSSSISLog
--------------------------------------------------------------------------------------------------------------------------
|
Logging In SSIS
|
Control Flow:
Execute Sql Task(SQL_Write_Into_Table)
~
DECLARE @PkgName VARCHAR(50) = ?
INSERT INTO TblPkg(PkgName,ExecTimeStamp) SELECT @PkgName,Getdate();
~
Right click anywhere on the package, see "Logging".
Containers Providers and Logs Details
ExecuteUtility Provider type:
SQL_Write_Into_Table
Note:
i. In "Containers" : Task wise ii.Providers and Logs:Where u want to log. iii.Details: which Events.
--------------------------------------------------------------------------------------------------------------------------
