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

  • True, that's is why I edited my earlier response when you pointed that out, changing component to task (which is what I had originally meant - wrong term).

    The solution does require all file rows to pass through the data flow's script component in order to flag the row with the correct file type and then conditionally splits from there. I don't see that as notable issue because all records are likely going to have to pass through a data flow somewhere in order to be processed (substantially large files could see a performance issue, I suppose, by running each record through that script component ... that'd have have to be tested/evaluated based on business needs, as would the selected solution at the end of the day).

    I'm glad that the sample package and related files worked! (first posting/response with supporting documentation/examples like that)

    Thanks!

    😀