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

  • I've just checked your solution - the data flow starts by using a Script Component to check the file type - and every single row of every file will go through that component, despite your original quote:

    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.

    Nonetheless, an interesting working example - thanks for posting it.

    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.