I can't remember the exact syntax in SSIS but you need to do a replace using the ASCII code for tab which you can find at http://www.asciitable.com/. You can do this with an expression in the derived column transform. There may be another transform you could use as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question