My source is currently Excel Source(excel file which i don't want to change). I would really appreciate if you would help me by modifying in the code below

using System;

using System.Collections.Generic;

using...

Thanks for the information. but i'm creating a package programmatically. Before mapping the source tom destination columns i need to cast appropriate columns. I've posted my problem in this site.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/6df92ab6-2695-4162-9b2a-b2cdff807462/?prof=required

how do we get the source to do it?:unsure: