'Handling Extra column data in SSIS

I have an excel with 10 columns(Headers) as 6th column is empty column. When I converted to text file, I got 9 columns(Removing empty column) but the data rows are 10. How can I handle to exclude empty data row

ssis


Solution 1:[1]

You can use a conditional split transformation :

  • Rename the Output Name to : Remove all empty rows
  • Set the condition to : ISNULL(Col1) && ISNULL(Col2) && .... && ISNULL(ColN)
  • When connecting your “Conditional Split” to your destination, SSIS will ask you what output the “Conditional Split” needs to return. To output the entire set without the empty rows, chose the “Conditional Split Default Output”: enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Amira Bedhiafi

Related Questions