OLE DB Destination

• ganteng1

  Ten Centuries

  Points: 1183

  More actions

  April 26, 2014 at 4:52 pm

  #284996

  Hello everyone. Can anyone please tell what effect of Selecting "Keep Nulls" and "Keep Identity" has on the data when using an OLE DB Destination.

  Thanks for your help

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  April 26, 2014 at 5:06 pm

  #1709005

  From mssqltips: http://www.mssqltips.com/sqlservertip/1840/sql-server-integration-services-ssis-best-practices/[/url]

  Keep Identity - By default this setting is unchecked which means the destination table (if it has an identity column) will create identity values on its own. If you check this setting, the dataflow engine will ensure that the source identity values are preserved and same value is inserted into the destination table.

  Keep Nulls - Again by default this setting is unchecked which means default value will be inserted (if the default constraint is defined on the target column) during insert into the destination table if NULL value is coming from the source for that particular column. If you check this option then default constraint on the destination table's column will be ignored and preserved NULL of the source column will be inserted into the destination.

  From Technet: http://technet.microsoft.com/en-us/library/ms188439.aspx

  Keep identity

  Specify whether to copy identity values when data is loaded. This property is available only with the fast load option. The default value of this property is false.

  Keep nulls

  Specify whether to copy null values when data is loaded. This property is available only with the fast load option. The default value of this property is false.

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]