I'm a novice to SSIS and one transformation I've never worked with before is The Conditional Split Transformation. I have a scenario where I need to split payments in 2 separated tables, where certain conditions are met. I've been fighting to get some logic to the syntax and how to write the conditions but it always me errors.
The code I attached is how I would like to split the payments. Is there any way to write those select statements as a condition in the Conditional Split Transformation Editor?
SELECT SUM(19-DATEPART("dd",gsdgsvfr)) as payment1,
SUM(gsfjodag- (19-DATEPART("dd",gsdgsvfr))) as payment2
Group by [gsnumrec]
the type of those fields used:
[gsdgsvfr] [char](10) NULL
[gsdgsvti] [char](10) NULL
[gsfjodag] [smallint] NULL