When the XMLTask has an OperationType set to Diff, then this enumeration is used to sets the options that affect the behavior of the comparison, as well as the resulting XDL DiffGram. The enumerations used will determine what items are included for consideration during the comparison.
네임스페이스: Microsoft.SqlServer.Dts.Tasks.XMLTask
어셈블리: Microsoft.SqlServer.XMLTask (in microsoft.sqlserver.xmltask.dll)
구문
‘선언
<FlagsAttribute> _
Public Enumeration DTSXMLDiffOptions
[FlagsAttribute]
public enum DTSXMLDiffOptions
[FlagsAttribute]
public enum class DTSXMLDiffOptions
/** @attribute FlagsAttribute() */
public enum DTSXMLDiffOptions
FlagsAttribute
public enum DTSXMLDiffOptions
Members
| Member name | Description |
|---|---|
| IgnoreChildOrder | Specifies that the order of child nodes of each element is ignored. When this option is selected, two nodes with the same value that differ only by their position among sibling child nodes are treated as the same nodes. |
| IgnoreComments | Specifies that Comment nodes are not compared. |
| IgnoreDtd | Specifies that document type declaration (DTD) is not compared. |
| IgnoreNamespaces | Specifies that the namespace Uniform Resource Identifiers (URIs) of the element and attribute names are not compared. This option also implies that the name prefixes are ignored. |
| IgnorePI | Specifies that the namespace URIs of the element and attribute names are not compared. This option also implies that the name prefixes are ignored. |
| IgnorePrefixes | Specifies that the prefixes of element and attribute names are not compared. When this option is selected, two names that have the same local name and namespace URI, but have a different prefix, are treated as the same names. |
| IgnoreWhitespace | Specifies that significant white spaces are not compared and that all text nodes are normalized by discarding any leading and trailing white space characters (#x9, #x10, #x13, #x20) and replacing sequences of white space characters with a single space (#x20) character. |
| IgnoreXmlDecl | Specifies that the XML declaration is not compared. |
| None | Specifies that that none of the options found in the enumeration are used. |
예
The following code example assumes that an XMLTask has been created as myTask, with an OperationType set to Diff.
myTask.OperationType = DTSXMLOperation.Diff;
myTask.DiffAlgorithm = DTSXMLDiffAlgorithm.Fast;
myTask.DiffOptions = DTSXMLDiffOptions.IgnoreDtd;
// To set multiple options, use OR.
// myTask.DiffOptions = DTSXMLDiffOptions.IgnoreDtd or DTSXMLDiffOptions.IgnoreComments;
myTask.OperationType = DTSXMLOperation.Diff
myTask.DiffAlgorithm = DTSXMLDiffAlgorithm.Fast
myTask.DiffOptions = DTSXMLDiffOptions.IgnoreDtd
' To set multiple options, use OR.
' myTask.DiffOptions = DTSXMLDiffOptions.IgnoreDtd or DTSXMLDiffOptions.IgnoreComments
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.