Loading a varchar/datetime value from a pipe delimited file to SQL table

hey all,

i have pipe delimited file get, , trying load in sql table. file looks this:

19,23,a,20130615062429

i have created sql table 4 columns int,int,char,datetime datatype respectively.

i not sure, if value getting in file is datetime/varchar. package runs fine when use varchar datatype in table (and not datetime).

i run in error, if use "datetime" datatype.

any ideas/suggestions?

you must implement logic convert '20130615062429' value into '2013-06-15 06:24:29' format should work datetime datatype column

http://uk.linkedin.com/in/ramjaddu

SQL Server > SQL Server Integration Services

My fan