Troubleshoot data integration issues
- Performance issues
- Performance Counters (http://msdn.microsoft.com/en-us/library/ms137622.aspx)
- Connectivity issues
- Execution of a task or transformation failed
- Logic issues
- Demonstrate awareness of the new SSIS logging infrastructure (http://msdn.microsoft.com/en-us/library/ms140246.aspx)
- Troubleshoot a failed package execution to determine the root cause of failure
- Troubleshoot SSIS package failure from an invalid datatype
- Implement break points
- To see variables changed values use set the RaiseChangeEventProperty = True
- Data viewers (http://msdn.microsoft.com/en-us/library/ms140318.aspx)
- Profile data with different tools
- Batch cleanup
Implement auditing, logging, and event handling
- Audit package execution by using system variables
- Propagate events
- Use log providers (http://msdn.microsoft.com/en-us/library/ms140246.aspx)
- Log an SSIS execution (http://msdn.microsoft.com/en-us/library/ms140246.aspx)
- Create alerting and notification mechanisms
- Use Event Handlers in SSIS to track ETL events and errors (http://msdn.microsoft.com/en-us/library/ms140223.aspx)
- Implement custom logging
Deploy SSIS solutions
- Create and configure an SSIS catalog (http://msdn.microsoft.com/en-us/library/hh479588.aspx)
- Deploy SSIS packages by using the deployment utility (http://msdn.microsoft.com/en-us/library/ms141693.aspx)
- Deploy SSIS packages to SQL or file system locations
- Validate deployed packages
- Deploy packages on multiple servers
- Create and map environment variables (http://msdn.microsoft.com/en-us/library/hh213230.aspx)
- Install custom components and tasks (http://msdn.microsoft.com/en-us/library/ms403356(v=sql.120).aspx)
- Install using gacutil
- Deploy SSIS packages by using DTUTIL (http://msdn.microsoft.com/en-us/library/ms162820.aspx)
Preparation resources