Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-06-18 : 06:35:16
|
How to retain NULL value for DATETIME Column in the case of empty value import from Flat File using SSIS...... It inserted as default datetime '1900-01-01'--Chandu |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 06:43:25
|
use derived column transformation. inside use conditional operator and for nulls use (DT_DATE) NULL or (DT_DBDATE)NULL if file data is NULL------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|