Post reply

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

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply