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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to convert Null or empty datetime value to default datetime value using SSIS derived column

Status
Not open for further replies.

burakcan

Programmer
Oct 10, 2011
39
CA
Hello,

How can I convert Null or empty datetime value to default datetime value ("1900-01-01") using SSIS derived column transformation in SSIS?
I need to check both empty or Null date values.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top