We have excel with one column which is actually Custom column and
type is h:mm:ss (when I right click and seleting
So when I'm selecting any of the cell into the excel file, it has values in the for of
h:mm:ss but when I look above the value "fx" it is different some thing like
date + time + AM/PM ( for the same seleted cell ) ---- which means two different values for the same selected cell.
Now we need to load this excel file using SSIS to our DB table, I tried but it is loading upper value ( date + time + AM/PM ) and not the value which the selected cell is having h:mm:ss.
Suppose for an example I have selected on cell whose value is 41:48:57 but when I see above near by to
fx it is having 1/1/1900 4:14:40 AM and SSIS is loading this value and not the actual value ( 41:48:57 "h:mm:ss" format).
So how to tell SSIS to load value in the form of h:mm:ss and not the date+time+AM/PM value? Tried my best to explain you guys.
Please let me know if you have any specific quesiton.
View Complete Post