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 |
|
abenitez77
Yak Posting Veteran
53 Posts |
 Posted - 2010-11-21 : 19:49:53
|
| I get this error msg when i try to import a sql 2000 table to a sql 2008 sql server.Copying to [dbo].[OI_VEND_PACK_SORTED_NODUPS] (Error)MessagesError 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.".An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid data for type "numeric".". (SQL Server Import and Export Wizard) |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2010-11-21 : 20:16:17
|
That It means one of the columns you are transferring has non-numeric data, hence the message "Invalid data for type "numeric". The other messages are just noise that happens when the first error hits.Double check your column mappings, and make sure that columns have the same datatype.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
DTS error msg with Numeric