sql server - Nullable Datetime From Derived Column -

sql server - Nullable Datetime From Derived Column -

extracting info flat file. field in question comes in string , formatted fit db column of type datetime. field allows null in database , file contains nulls , valid strings convert dates in field.

ssis throwing error when seek , pass nulls on database.

error

error: exception has occurred during info insertion, message returned provider is: sqldatetime overflow. must between 1/1/1753 12:00:00 , 12/31/9999 11:59:59 pm.

data conversion code ([po scheduled ship date] == "") ? null(dt_dbtimestamp) : (dt_dbtimestamp)(substring([po scheduled ship date],1,4) + "-" + substring([po scheduled ship date],5,2) + "-" + substring([po scheduled ship date],7,2)) dataviewer sample

db column definition

this because variable of type date fails set wrong value. figure out record can utilize dataviewer please, check you're not sending out-of-range date "jan 1st 0001", or invalid date 9999-99-99 or 00-00-0000

dataviewer : http://msdn.microsoft.com/en-us/library/ms140318.aspx

sql-server datetime ssis null ssis-2012