SSIS event logging
To log all the events that will be helpful for troubleshooting the package.
What are the different SSIS log providers?
SSIS log provider for Text files
SSIS log provider for Windows Event Log
SSIS log provider for XML files
SSIS log provider for SQL Profiler
SSIS log provider for SQL Server (Data will be stored in msdb..sysdtslog90/msdb..sysssislog table)
What is SSIS event logging? was last modified: October 1st, 2017 by Justin Antony
transaction support feature SSIS
If a package fails in the middle then SSIS used this functionality to start the execution from the place where it failed. Also the transactions gets roll-backed aswell if needed.
Supported – Parent object has initiated a transaction and child package will participate in it this transaction
Required – This will create and start a new transaction
NotSupported – This will not support the transaction
We need to enable MS DTC (Microsoft Distributed Transaction Coordinator) Windows Service for transaction support
What is the transaction support feature in SSIS and how to configure it? was last modified: October 1st, 2017 by Justin Antony