SQL Server Performance

data flow component

Discussion in 'SQL Server 2005 Integration Services' started by tboonleong, Apr 10, 2007.

  1. tboonleong Member

    SELECT (CASE WHEN mUnit.OwnershipType = '001' THEN ISNULL (mUnit.LeasedStartDate,'1/1/1900')
    WHEN mUnit.OwnershipType = '002' THEN ISNULL(mUnit.SalePurchaseDate,'1/1/1900')
    ELSE '1/1/1900' END)
    AS UnitAcquiredDate
    From mUnit

    Arcoding to the SQL statement above,any data flow component in the SSIS can use to get the same result?Thanks.
    tboonleong, Apr 10, 2007
    #2

  2. satya Moderator

    satya, Apr 15, 2007
    #2

Share This Page