how to check if file contains only column headers without data

• caojunhe24

  Ten Centuries

  Points: 1334

  More actions

  October 14, 2019 at 2:58 pm

  #3688518

  Hi All,

  i have a task to check file (excel & text) before loading to a table.

  checking condition: if file only contains header(columns) without any data then fail the file.

  I have filename & source file path variables already - any idea how to handle this in script task?

  much appreciate!

   

• tim.ffitch 25252

  SSCrazy

  Points: 2055

  More actions

  October 14, 2019 at 3:13 pm

  #3688527

  Set up your connection manager with column headers. In your data flow task add a Row Count as the first transform in the data flow and store the count in a variable , the next transform should then be a conditional split where you read the Row Count where you can then decide what to do if it = 0 or not.

• caojunhe24

  Ten Centuries

  Points: 1334

  More actions

  October 14, 2019 at 3:52 pm

  #3688551

  thanks tim,

  what i want to design is even before going to data flow i want to perform all the checks and based on the condition i have all the follow up tasks for failing the file- so in this case i have to use script task to perform this validation.

   

• palandri

  Old Hand

  Points: 387

  More actions

  October 14, 2019 at 4:31 pm

  #3688591

  You could implement caojunhe24's suggestion in a separate data flow, store the row count in a package variable, and test it before branching to your primary data flow.