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 |
|
micky--4444
Starting Member
19 Posts |
 Posted - 2007-04-18 : 08:34:08
|
| Hello,I've just taken over a project and there's an issue with null values in some fields.The XML file is loaded into SQL Server 2005 with the SQLXMLBulkLoadThe XML file is about 60mb.Anyone any ideas, the fields in particular that seem to be causing the issue are of type ntext and allow nulls.thanks. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-04-18 : 10:45:43
|
| I doubt I can help, but I can tell you that unless you tell us what the "issue" is, no-one here can help you. |
 |
|
|
SatyaSKJ
Starting Member
46 Posts |
Posted - 2007-04-19 : 06:52:59
|
| http://doughennig.blogspot.com/2006/07/sqlxmlbulkload-rocks.html fyi, on the other XML related newsgroups it has been suggested that "If you get "Internal error", that's a bug. However, you cannot assign to ntext parameters anyway". See whether you can use a temp table in this case to handle that part of data with relevant data types.Satya SKJSQL Server MVPhttp://www.sqlserver-qa.net |
|
|
|
|
|
|
SQLXMLBulkLoad