Wednesday, October 16, 2013

SSIS:Logging

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 

No comments:

Post a Comment