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 |
|
em00guy
Starting Member
6 Posts |
 Posted - 2006-12-27 : 20:21:40
|
| I'm attempting to bulk copy delimited files into my MS SQL 2005 db. Some of the columns in the destination table are of type numeric. Consequently, SQL throws an InvalidOperationException when attempting to convert from a string to a decimal. Does any one know of a way to remedy this problem? Changing the table column typed is unfortunately not an option. Thanks alot. here is my error:An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dllAdditional information: The given value of type String from the data source cannot be converted to type decimal of the specified target column. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-28 : 04:48:07
|
what is your decimal separator? it must be a .Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
sqlBulkCopy Problems