Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GerhardSA
Starting Member
2 Posts |
 Posted - 2008-11-06 : 08:32:30
|
| i quote:"- Copying to [Full ECSA Web Database].[dbo].[CPDMembers] (Error)Messages• Error 0xc0202009: Data Flow Task: 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". (SQL Server Import and Export Wizard) • Error 0xc020901c: Data Flow Task: There was an error with input column "DateFrom" (108) on input "Destination Input" (80). The column status returned was: "Conversion failed because the data value overflowed the specified type.". (SQL Server Import and Export Wizard) • Error 0xc0209029: Data Flow Task: The "input "Destination Input" (80)" failed because error code 0xC020907A occurred, and the error row disposition on "input "Destination Input" (80)" specifies failure on error. An error occurred on the specified object of the specified component. (SQL Server Import and Export Wizard) • Error 0xc0047022: Data Flow Task: The ProcessInput method on component "Destination - CPDMembers" (67) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. (SQL Server Import and Export Wizard) • Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0209029. (SQL Server Import and Export Wizard) • Error 0xc02020c4: Data Flow Task: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. (SQL Server Import and Export Wizard) • Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - CPDMEMBERS" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. (SQL Server Import and Export Wizard) • Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038. (SQL Server Import and Export Wizard)"IT SEEMS TO ME THAT THERE IS AN ERROR WITH THE DATETIME DATA TYPE.Im importing from Access to SQl 2005, and in the Access table there is about 43 000 records, and only about 18 900 gets imported to SQL, then i get this error.PLease help me guys...im bit stunned by this |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-06 : 09:04:54
|
It means it can't interpret the string value as a date.For example, is "11/1/2008" Nov 1 or Jan 11?Is "31/12/2008" Dec 31 or #Error?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
GerhardSA
Starting Member
2 Posts |
Posted - 2008-11-07 : 03:41:17
|
| I didnt create the access database, but i do know that there was an issue previously where clients did complain that there birthdates were wrong and said that on the website their birthdate says July 9th, insted of September 6th ( e.g 06091980)We use European dates(im south african), this its always, day/month/year for dates, and not month/day/year like the Americans do.Thanks..ill look into it... i want to get rid of this access database and replace it with SQL, but i need to import all the data first.Thanks |
|
|
|
|
|
|
|
|
Data overflow error with Import Wizard