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