It is the delimiter that I am having trouble with. For example and address that has a comma in it. Before I could force DTS to see say 40 spaces and drop the item in there comma or no comma. In SSIS I cannot seem to do that. I have tried Fixed width but that is not working either. I have gone to replace(field,',',' ') for name and address.