When you import a text file, you have to make sure number and text fields are differentiated from each other. Typically, you would surround a value that is text with quotes: " ". Your import is treating every field as a number, thus only number values are imported. You need to do one of two things:
1. Make sure each field that should be text is surrounded by quotes for each record: 101,10," 1","04","2South"
2. Create an import specification, which would be much easier. You can do this by importing your file manually from the database window - set up the parameters for each field and save it. Then you can use this specification in your TransferText action (one of the parameters should be for an import/export specification).