Default date in a derived column expression

Hot Topic

Month and day of imported datetimes are switched
DEPLOY packages from Server A to Server B.
Database level lock
OLAP cube migration problem
Download for redistributable SQL Server Express Edition?
SQL Server Assertion ERROR
A data source instance has not been supplied for the data source
Is it possible to do?
HideMemberIF: Parent vs. Only Child w/ Parent
multiple partitions management at once

SQL Server

Where does this message come from and why?
programmatically setting package variables in job step command line
YTD
Mix and Match Rows
SQL Query Help....
Comparing millions of records from file A and B
Determine Processor Architecture for SQL Server 2005
update stored proc super slow
Manual validation of external metadata
Importing an XML file with hirarchial data

Default date in a derived column expression

one of my SSIS packages use this expression to put todays date in if it is NULL:

(ISNULL(datejs)) GETDATE() : datejs

however, what I really want to do though is put a default date in like '2007-01-01' but I get syntax error because SSIS thinks it's a string, which it is I suppose.

Is it possible to do what I want it to

Thanks

 

 

 

 

Answer this question

Default date in a derived column expression

  • mhodder

    Try casting it

    (ISNULL(datejs)) (DT_DBTIMESTAMP)"2007-01-01" : datejs



  • hwiz

    Fresh from the Integration Services Expression Reference section of Books Online, we have the GETDATE (http://msdn2.microsoft.com/en-US/library/ms139875.aspx) topic. So using GETDATE is possible, but sounds like a variable or literal casted as you suggest is actually what is needed here.

  • wraithzshadow

    Larry Charlton wrote:

    Try casting it

    (ISNULL(datejs)) (DT_DBTIMESTAMP)"2007-01-01" : datejs

    That's done it. Thank You.
  • Default date in a derived column expression
Answer this question