Q:

Date format conversion of cvs column to table column using SSIS Package?

I am using SSIS package to import data from cvs file to table.
CVS File

Report_Date
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125
20140125

I want to convert in to 2014-02-05 date format.How can i do that in ssis Package.I tried with convert and casting but i was not successfull.Can any one help me ?

A:

You can use CONVERT( function to change that into date. For example 
SELECT CONVERT(DATE,'20140210',112)

After you change it into date you can output it into any format that you want. 
Read http://msdn.microsoft.com/en-us/library/ms187928.aspx for list of all styles that you can use for DATE when converting it. 112 stands for yyyymmdd format.
if date is stored as Numeric field you will need to convert it to VARCHAR before converting it to DATE, 
SELECT CONVERT(DATE,CONVERT(VARCHAR(10),20140204),112)

