Question

I m 操作以下法规:

    Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
    objBL.ConnectionString = "provider=SQLOLEDB.1;data 

    source=mySQLServer;database=myDB;uid=SA;pwd=myPword"
    objBL.ErrorLogFile = "c:error.log"
    objBL.Execute "c:xmlschema.xml", "c:xmladdresses.xml"
    Set objBL = Nothing

I m试图将一个相当庞大的XML文件装入SQ表,但I m接收错误的“Cannot在LocID栏中加上UNL的价值,表我的DB.dbo.myTable ;一栏不允许作废。 INSERT 失败

"LocID" is my primary key and Identity field. Is there a way to prevent it from inserting NULL into this column, since I m just loading data, not moving it and I don t have ID fields in the XML file?

Answer 1

在I.BL.之前加上这一点。概述

objBL.KeepIdentity = False

http://msdn.microsoft.com/en-us/library/ms1769.aspx” rel=“nofollow noreferer”

KeepIdentity

Specifies how to deal with the values for an Identity type column in the source file. This is a Boolean property. When the property is set to TRUE, XML Bulk Load assigns the values that are specified in the source file to the identity column. When the property is set to FALSE, the bulk-load operation ignores the identity-column values that are specified in the source. In this case, SQL Server assigns a value to the identity column.

If the Bulk Load involves a column that is a foreign key referring to an identity column in which SQL Server-generated values are stored, Bulk Load appropriately propagates these identity values to the foreign key column.

The value of this property applies to all columns involved in the bulk load. The default value is TRUE.

Answer 2

如果你将BulkInsert输入一个数据库,那么你就应当把Bulk插入每个哥伦卡为NUL的临时表格,并且通常把我的Size安排到VARCHAR(800)。

一旦被列入这些表格,即进入电子计算中心,并将其装入我的主表。

希望帮助你们。

友情链接