SSIS excel sheet to table RRS feed

  • Question

  • hi all i have a column in excel sheet called  ISDBTSTAMP and has data eg "0X000000000001AB19 " . now i am trying to load all these columns into a stage table. i tried to map this excel column ISDBTSTAMP by using a data conversion transformation to covert to databasetime  with precision, database timestamp  E.t.c , non of them work i always get error "the oledb provider used by oledb adapter cannot convert between types "DT_DBTIME2" and DT_BYTES. can some one suggest.
    Wednesday, July 27, 2011 5:21 AM


All replies