May 12, 2002 at 9:51 pm
I want Import data from Excel,it have field value is '00:30:00',after import,the value in mssql is '',why?
how can I get correct value?
May 13, 2002 at 4:43 am
Did you check the transformation to see what it is mapping to? Also have seen statements made when the column has other types of data inside it, are any other columns acting odd?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 16, 2002 at 7:41 pm
Thanks for your reply!
but I except your tell me condition,the value still is error.
perhaps,you can try it,new a excel file,input data which format like '00:27:54',you may be get error value at DTS preview.
CAN YOU HELP ME?
May 16, 2002 at 7:41 pm
Thanks for your reply!
but I except your tell me condition,the value still is error.
perhaps,you can try it,new a excel file,input data which format like '00:27:54',you may be get error value at DTS preview.
CAN YOU HELP ME?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply