Better Know A SSIS Transform – Conditional Split

Who is online?  0 guests and 0 members
Home  »  Blogs  »  DevinKnight  »  Better Know A SSIS Transform – Conditional Split
 
0
/5
Avg: 0/5: (0 votes)

Comments (2)

shauntih
shauntih said:
I'm trying to use a conditional split to discard rows before saving data to a flat file destination. The conditional split doesn't appear to be working. I have two conditions (which contain what I want to discard) and the default output is what I want to keep. I have the default output going to the destination file. Unfortunately, the split isn't working and all data is being passed to the file. I imported the data into a test table and ran the following queries against it, verifying there are 5 rows total which should be excluded. ------------- Discard condition 1 (1 row): select * from Report1 where [Patient Status] = 'P' and [Admit Date - Date only] is null Discard condition 2 (4 rows): select * from Report1 where [Patient Type] = 'ED' and [Discharge Date] is null and [Insurance 1 Plan Code] ='' ------------- The conditional split conditions are listed below: ------------- Discard condition 1: [Patient Status] == "P" && ISNULL([Admit Date - Date only]) Discard condition 2: [Patient Type] == "ED" && ISNULL([Discharge Date]) && [Insurance 1 Plan Code] == "" ------------- I am clearly missing something. I cannot figure out why this isn't working. Any help would be greatly appreciated!
3/19/2010
 · 
 
by
DevinKnight
DevinKnight said:
You likely need a conditional expression (?:) with the ISNULL. http://msdn.microsoft.com/en-us/library/ms141184.aspx
3/21/2010
 · 
 
by
Blogs RSS Feed

DevinKnight's latest blog posts

Blogs RSS Feed

Latest community blog posts