Scenario:Our team has deployed different SSIS Packages those are running in Production. The team had made sure that the logging and error notification is implemented. Once in a while when our SSIS Package/s fail in Production, We get an email with error e.g. Execute SQL Task 1 failed with bla bla error and this error is also logged in text file. By looking at the email or log file, we can't really tell what exactly Execute SQL Task 1 was doing and what was the position of this Task in the SSIS Package, even it is every first or the last task in the SSIS Package.
- The Actual name provided by SSIS such as Execute SQL Task, Data Flow Task, OLE DB Connection Manager, For Each Loop Container etc.
- The Purpose for what I need to use this Item.