SQL Server SSIS Sample Component: NullDetector

    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.
    • Version:


      File Name:


      Date Published:


      File Size:

      119 KB

        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
    • Supported Operating System

      Windows 2000, Windows Server 2003, Windows XP

        SQL Server 2005; Visual Studio 2005
      • Install and build as directed in readme.txt

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial