importing flat file to sql - error on datetime column in ssis 2005.
An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". The datetime field is imported using a temporary table as char(10) then sent to oledb SQL table. I changed the field in sql table to to char(10) - this worked in 2000 DTS but receiving error now. There are blanks in this field ... could this be the cause?
Please let me know how I can resolve this asap. thanx, barb