See this page for all SSIS casts:
f.e. varchar(8) = (dt_str, 8, 1252)[column]
Please mark the post as answered if it answers your question | My SSIS Blog:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?