SQL Server SSIS Sample Component: NullDetector
Brief Description
NullDetector is an SSIS dataflow component that sits astride a data flow, and, depending on whether the value of a user-indicated column is null or not, routes rows to one or the other of its outputs.
On This Page
Quick Details
| File Name: | SetupNullDetector.msi |
| Version: | 1.1 |
| Date Published: | 1/26/2006 |
| Language: | English |
| Download Size: | 119 KB |
| Estimated Download Time: | 1 min 56K |
Overview
Configure the component by selecting the test column on the "Input Columns Tab" of the advanced editor. Leave the usage type set to READONLY.
To test this component, you can wire it up after UnDoubleOut, which produces null results for any badly formatted qualified text.
This component is part of a series of components that illustrate increasingly complex behavior, each one exercising a greater proportion of the SSIS object model. If studying in order, this component follows UnDoubleOut, and precedes UnDoubleError.
This component was built to provide an introduction to the use of the "virtual buffer". Also included are:
- ProvideComponentProperties and the second output.
- Using DirectRow in ProcessInput.
- PostWarning 
Top of page
System Requirements
- Supported Operating Systems: Windows 2000; Windows Server 2003; Windows XP
SQL Server 2005; Visual Studio 2005 Top of page
Instructions
Install and build as directed in readme.txt
Top of page
Top of page
