DTS - Import CSV

Okay guys im having a problem... i've created a DTS package to import a CSV file, but all fields containing integers shoot me an error stating that it can't insert a STRING into an INTEGER column...

Does anybody know how to circumvent this? I've googled it to death and still can't come up with a solution. Maybe i'm asking for the wrong thing... who knows... PLEASE HELP!!!Would it be better if i just imported an xls or mdb or someething?|||Hi,

you might want to open the .csv file in Excel and check if the particular columns that are causing the problem are not of text type.

Cheers,
Ziyi|||every entry in this colum is integer... meaning no characters, just numbers...