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 whathttp://msdn2.microsoft.com/en-us/library/ms136078.aspx you are after. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
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.

---

]]>