You just gave a high level detail of your question. If you are just trying to load data into a SQL Table from a CSV file using SSIS, here is an article I wrote on using SSIS to load a CSV file to a table. http://sqlsaga.com/ssis/how-to-load-data-into-a-database-table-from-an-excel-spreadsheet-using-ssis/[/url]

And regarding changing the data types, you can do that when creating the table accordingly.