Share via


IDTSBulkInsertTask.KeepNulls Property

This API supports the SQL Server 2012 infrastructure and is not intended to be used directly from your code.

Gets or sets a value that indicates whether empty columns should retain a nulla null reference (Nothing in Visual Basic) value during the bulk load operation, or insert default values into the columns.

Namespace:  Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
Assembly:  Microsoft.SqlServer.BulkInsertTask (in Microsoft.SqlServer.BulkInsertTask.dll)

Syntax

'Declaration
Property KeepNulls As Boolean 
    Get 
    Set
'Usage
Dim instance As IDTSBulkInsertTask 
Dim value As Boolean 

value = instance.KeepNulls

instance.KeepNulls = value
bool KeepNulls { get; set; }
property bool KeepNulls {
    bool get ();
    void set (bool value);
}
abstract KeepNulls : bool with get, set
function get KeepNulls () : boolean 
function set KeepNulls (value : boolean)

Property Value

Type: System.Boolean
true if empty columns should retain a nulla null reference (Nothing in Visual Basic) value during the bulk load operation; false if the specified default values should be inserted instead.

Remarks

For more information, see BulkInsertTask.

See Also

Reference

IDTSBulkInsertTask Interface

Microsoft.SqlServer.Dts.Tasks.BulkInsertTask Namespace