data flow component | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

data flow component

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.
Is this is what you are after. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.