skip to main
|
skip to sidebar
Business Intelligence Scrap Book
Monday, June 9, 2008
CASE Statements Syntax in SSIS
Found the way to write case statements in SSIS. Knew it could be done in the Derived Column transformation but did not know the syntax.
The syntax is:
case
?
true
:
false
Eg:
Cust_Limit >= LKP_CustomerLimit
?
Cust_Limit
:
LKP_CustomerLimit
Newer Post
Older Post
Home
Labels
Analytics
(1)
Best Practices
(1)
Big Data
(1)
Blogs
(1)
Business Intelligence
(3)
Cache Transformation
(1)
Cloud
(2)
Cube Browser
(1)
Dashboards
(1)
Data Vault
(1)
Data Visualization
(4)
Date Dimension
(1)
Deployment
(1)
Derived Column Transformation
(2)
Documents
(1)
ETL
(1)
For Me
(1)
Free
(3)
Future BI
(2)
General
(1)
issuu
(1)
Live Chat
(1)
Lookup Transformation
(1)
Madison
(1)
Master Data Management
(1)
Media
(1)
Merge Join
(1)
Microsoft BI
(1)
Performance Management
(1)
Practice Management
(1)
Predictive Analytics
(1)
Query
(2)
Resolution
(1)
Row Count Transformation
(1)
SAP Business Objects
(1)
Script
(1)
SharePoint Foundation
(1)
Silverlight
(1)
Slowly Changing Dimension
(1)
Software
(1)
SQL Server 2005
(4)
SQL Server 2008
(3)
SSAS
(2)
SSIS
(16)
SSRS
(1)
Stored Procedure
(1)
T-SQL
(2)
Tableau
(1)
Tamil
(1)
Templates
(1)
Thoughts
(2)
Unstructured Data
(1)
Utilities
(1)
Virtual Earth
(1)
Web
(1)
white paper
(1)
XML Transformation
(1)
My Links
Triple M Sydney