That did not work for me.

So what I finally did for a csv source to Table. I added a data convesion task and the one coulum which was a headache, I created alises for that and then set that coulmn's the data type as the destination table.

so it worked and all got copied but I don't like it.

I am going to try Excel now and I am afraid it not going to work