Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Handle NULL data in datetime field
I have a database field birth_date (datetime, null) My source file has birth_date column which is having 'NULL' as data in all the rows. I used a derived column transformation to have datatime column and used the expression as : TRIM(birth_date) == "" ? (DT_DBTIMESTAMP)NULL(DT_DBTIMESTAMP) ...- dorsun
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Integration Services (SSIS)
