Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS Flat File Import - CSV Files with empty information RE: SSIS Flat File Import - CSV Files with empty information

  • October 10, 2012 at 12:24 am

    #1547470

    1. You can make use of String Funtions in Derived Transformation to make change as NULL.

    2. Then use Row Count Transformation to get the count of empty or null.

    3. If the Row Count is greater than one, then don't load it.

    Please try. This may help you! 🙂