Validate headers in .csv files in ssis

• p.shabbir

  SSCrazy

  Points: 2404

  More actions

  May 18, 2015 at 3:24 pm

  #300786

  Hi All,

  How to validate the .csv file. if the file is valid then do nothing or else move the file to archive folder.

  If the file contains less than 21 cols and any one of the headers present as below.

  EventName

  ServiceTransactionId

  ConversionTransactionId

  ConversionAmount"

  ConversionQuantity

  ConversionOrderId

  ConversionCategory

  ConversionSubcategory

  ConversionDateTime

  OrgId

  MessageID

  Then move the file to archive folder.If the file is valid then do nothing.

  How to achieve this one.Plz help.

  Thanks in advnc.