I have a flat file import routine that loops through csv files in a directory. These files have different data in them so have a different number of columns depending on which one it is. I have a conditional split which looks for the value in the equivalent of cell a1 which indicates what data to expect and then routes that through to the relevant staging table in the db. As an example of my issue, when the customer dimension file comes through, the flat file source brings 5 rows of data, I do not have first row assigned as column headers as this is variable. When it goes through the conditional splt, only one row (the header row) is being moved onto the next stage. Can anyone advise what may be causing this issue? And how to get around it. Any help would be greatly appreciated. David

Figured it out - turns out I'm just a bit thick...

David, I think, Now you used the default output of conditional split. correct me if I'm wrong.. Please share your solution with us..this may help others.. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/