How to convert varchar column into timestamp format with Data Conversion(SSIS Data Flow Item)?
I am getting date column in the source file(.csv) like 20080727063005. I need to load this value into Sql Server table as Datetime data type column.(yyyy-mm-dd hh:mi:ss FORMAT) Hope i can do it with Data Conversion . But i am new to SSIS. So can you please tell me how to solve this problem with Data conversion? or Is there any other easy method please let me know.
Thanks in advance.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.