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.

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