---
title: "SQL Server Destination Custom Properties | Microsoft Docs"
ms.custom: ""
ms.date: "03/14/2017"
ms.prod: sql
ms.prod_service: "integration-services"
ms.reviewer: ""
ms.technology: integration-services
ms.topic: conceptual
ms.assetid: b736aa6d-c154-44a0-be08-f25733fca1d9
author: chugugrace
ms.author: chugu
---
# SQL Server Destination Custom Properties

[!INCLUDE[ssis-appliesto](../../includes/ssis-appliesto-ssvrpluslinux-asdb-asdw-xxx.md)]


  The [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] destination has both custom properties and the properties common to all data flow components.  
  
 The following table describes the custom properties of the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] destination. All properties are read/write.  
  
|Property name|Data Type|Description|  
|-------------------|---------------|-----------------|  
|AlwaysUseDefaultCodePage|Boolean|Forces the use of the DefaultCodePage property value. The default value of this property is **False**.|  
|BulkInsertCheckConstraints|Boolean|A value that specifies whether the bulk insert checks constraints. The default value of this property is **True**.|  
|BulkInsertFireTriggers|Boolean|A value that specifies whether the bulk insert fires triggers on tables. The default value of this property is **False**.|  
|BulkInsertFirstRow|Integer|A value that specifies the first row to insert. The default value of this property is **-1**, which indicates that no value has been assigned|  
|BulkInsertKeepIdentity|Boolean|A value that specifies whether values can be inserted into identity columns. The default value of this property is **False**.|  
|BulkInsertKeepNulls|Boolean|A value that specifies whether the bulk insert keeps Null values. The default value of this property is **False**.|  
|BulkInsertLastRow|Integer|A value that specifies the last row to insert. The default value of this property is **-1**, which indicates that no value has been assigned.|  
|BulkInsertMaxErrors|Integer|A value that specifies the number of errors that can occur before the bulk insert stops. The default value of this property is **-1**, which indicates that no value has been assigned.|  
|BulkInsertOrder|String|The names of the sort columns. Each column can be sorted in ascending or descending order. If multiple sort columns are used, the column names are separated by commas.|  
|BulkInsertTableName|String|The [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] table or view in the database to which the data is copied.|  
|BulkInsertTablock|Boolean|A value that specifies whether the table is locked during the bulk insert. The default value of this property is **True**.|  
|DefaultCodePage|Integer|The code page to use when code page information is not available from the data source.|  
|MaxInsertCommitSize|Integer|A value that specifies the maximum number of rows to insert in a batch. When the value is zero, all rows are inserted in a single batch.|  
|Timeout|Integer|A value that specifies the number of seconds the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] destination waits before termination if there is no data available for insertion. A value of 0 means that the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] destination will not time out. The default value of this property is 30.|  
  
 The input and the input columns of the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] destination have no custom properties.  
  
 For more information, see [SQL Server Destination](../../integration-services/data-flow/sql-server-destination.md).  
  
## See Also  
 [Common Properties](https://msdn.microsoft.com/library/51973502-5cc6-4125-9fce-e60fa1b7b796)