Glad you got it working. Yes, datatypes can be frustrating sometimes in SSIS but honestly, you'll get used to them (and the errors, due to seeing them a few hundred times until you are) and it won't be as big a deal anymore.
Good luck!
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA