From the course: SQL Server Integration Services
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Conditional Split transformation - SQL Server Tutorial
From the course: SQL Server Integration Services
Conditional Split transformation
- [Instructor] Now let's take a look at adding a conditional split transformation to divide the incoming data set into two different tables. and once you find it, you can go ahead and double click on it or just click and drag it out and drop it into any position that you want. Just like before we need to feed the data in first. So, click the "Character Map" step and then drag the blue arrow and drop it on "Conditional Split". Then, double click it to configure it. Conditional Split will evaluate the content of a record against conditions that you specify. This will determine how to write the records and move them into multiple output paths. On the top left you have variables, perimeters, and the original table columns to work with. And on the right you have all the T sequel functions and operators that you can apply to build a conditional statement. One of the columns that we have in our data set is called "is employee". This is a Boolean data type that's true if the person is an…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Data flow components1m 49s
-
(Locked)
Extracting data from a source5m 43s
-
(Locked)
Understand transformations1m 15s
-
(Locked)
Character Map row transformation3m 50s
-
(Locked)
Conditional Split transformation5m 3s
-
(Locked)
Rowset transformations2m 25s
-
(Locked)
Loading data to a destination5m 37s
-
(Locked)
Prevent duplicate records2m 52s
-
(Locked)
-
-
-