0

Null Values in Date column

Aimsamcdev

March 29, 2011 16:29

None

Follow

 

Hi There,

I made some modifications just so that I get going. My insert into
destination SQL table is successfull for fields which are string type. But
if my flat file does not have data corresponding to the date column in
destination table, the dataflow fails to import records. The date column is
set to accept null values, but the import still fails. How do I handle
inserting null dates?

For the Identity insert I am using Sequence generator and inserting the
value explicitly. Is this the right way to do it?

 

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Mike O'Quinn March 29, 2011 16:30

  Thanks,

  For identity in SQL server, you can set 'Preserve System Generated Key Values' to unchecked to enable sql server to generate new keys. The sequence generator solution is also good if you want to control it from outside. Also, ensure that the identity field 'System Generated' is checked in the table layout grid.

• 0
  
  Aimsamcdev March 29, 2011 23:36

  That worked, thank you so much.