how to load data from flat file source into oledb destination by changing the data types in ssis

• vamsikrishnacheruku

  SSC Veteran

  Points: 224

  More actions

  April 16, 2014 at 10:39 am

  #285877

  i have an source file and i have to load it into the data base by changing datatype of the columns in ssis

• a4apple

  SSCrazy

  Points: 2620

  More actions

  April 16, 2014 at 10:42 am

  #1706535

  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.

  Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.