Home Forums Data Warehousing Integration Services Whats the easiest way to read the first 10 characters of a flat file RE: Whats the easiest way to read the first 10 characters of a flat file

  • dg227 (5/7/2013)


    Without PS or a script component, you can treat the data records in the given file as a single column text field. In the data flow, start with a conditional split looking at the substring(1,10,[field]) and divert the remaining records from there. The records can then be shredded in subsequent derived column fields based on your file definition/needs.

    This would divert only the first row.

    "..divert the remaining records from there"

    Please explain how you would implement this.

    Also, I suggested a Script Task, not a Script Component - there is a difference.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.