Question: how to convert yyyymmdd to date in ssis?
Answer: Add a Data Conversion Data Flow Component. Right click, Show Advanced Editor... Goto Input and Output Properties. Expand Data Conversion Output and click on the date column. Set FastParse to True in the Custom Properties. Make sure the data type is set to database date [DT_DBDATE]