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
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …