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 |
|
Ravi0435
Starting Member
47 Posts |
 Posted - 2007-06-20 : 11:03:22
|
| Hi , I have a column in my extract table as nchar(3) and in the destination (the same column with diff name ) it is decimal(3,0) .....i tried to use dataconversion transformation.....i even tried to use cast/convert fn's in the SQL Command (which i use in the "Source Transformation" to get the columns from the extract table).I tried all the ways i can and still i get the same error..:[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E07 Description: "Error converting data type nvarchar to numeric.". Can we actually do it...?? any help would be appreciated.thanksraviNothing much that i can do..!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-20 : 11:12:38
|
| Does the column have non-numeric value? |
 |
|
|
Ravi0435
Starting Member
47 Posts |
Posted - 2007-06-20 : 13:00:10
|
| yes that was the problem which i realised very late...as there were 200,000 records i couldnt check ...actually never thought as400 woulod send such bad data.thanks,raviNothing much that i can do..!! |
|
|
|
|
|
|
Conversion from nchar to numeric