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 |
|
JeffT
Posting Yak Master
111 Posts |
 Posted - 2008-05-15 : 12:13:45
|
| Hi,I have a process running SQLXMLBulkload.3.0 against an XML data file which is completing without issue. I cloned the same process for another XML data file but am getting an error I can't seem to resolve. I've checked the working process vs. the one not working (vbscripts, xml data files, xml schema files,etc.) and see no differences that might cause this error. The error when I run SQLXMLBulkload.3.0 is this: "Microsoft OLE DB Provider for SQL Server: All bound columns are read-only"Has anyone run across this before. We are running under sql server 2000.Thank you.J. |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-05-15 : 13:25:44
|
| Check the permissions on the database for the userid you are using for this process.An infinite universe is the ultimate cartesian product. |
 |
|
|
JeffT
Posting Yak Master
111 Posts |
Posted - 2008-05-15 : 13:37:23
|
| Will do...thanks very much !J. |
|
|
|
JeffT
Posting Yak Master
111 Posts |
Posted - 2008-05-15 : 13:48:38
|
| I checked the permissions and they look fine. Actually the userid/pswd is the same one I used for the process that is working but thanks for the suggestion. J. |
|
|
|
JeffT
Posting Yak Master
111 Posts |
Posted - 2008-05-16 : 14:23:17
|
| Figured this one out. Seems I had a table specified in the XML schema file (sql:relation=) with only one field, a single IDENTITY field. SQLXMLBulkload.3.0 does not like this because it must have at least one updatable (non-IDENTITY) field, so I had to create a dummy field in the table.Thanks |
|
|
|
|
|
|
SQLXMLBulkload.3.0 Error