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
In your SSIS package, use the build query option long enough to look at the entire dataset you're importing. Thoroughly scan that column for values that wont convert. You may have to use a Data Conversion
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …