This is a component for performing common data cleansing operations in the SSIS data flow. It's intended as an both a learning sample for SSIS custom components, and a working data cleansing component for common operations.
- Defaults for Null Values
- Format Numeric Strings
- Check Value against a Range
- Check Value against a List of Valid Values
This component shows the use of:
- Error Outputs
- Aquiring connections
- Custom properties on columns