SQL Server Performance Forum – Threads Archive
data flow componentSELECT (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)
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
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.