SSIS Conditional Split | Conditional Split | MSBI Tutorials
#SSIS #conditionalsplit #SSISTutorial #MicrosoftBI #ETL #DataCafe
This Tutorial explains How to use Conditional Split in Simple ETL package using SQL Server Integration Service.
SSIS Simple ETL:- • SSIS Simple ETL Tutorial | SQL Server...
SSDT Installation Steps:- • FREE Power BI Download, Install & Get...
SQL Management Studio:- • How to download and install SQL Serv...
SQL Server Installation:- • How to download and install Microsoft...
=====SOCIAL=====
👥Facebook: / datacafe4u
📶LinkedIn: / datacafe4u
📸Instagram: / datacafe4u
--Customer_Salary Table
Create table Customer_Salary(
CustomerKey varchar(50),
FirstName varchar(20),
LastName varchar(20),
Salary int
)
--Insert Queries
insert into Customer_Salary values ('AW00011001','Jon','Yang',90000)
insert into Customer_Salary values ('AW00011002','Eugene','Huang',90000)
insert into Customer_Salary values ('AW00011003','Ruben','Torres',60000)
insert into Customer_Salary values ('AW00011004','Christy','Zhu',50000)
insert into Customer_Salary values ('AW00011005','Elizabeth','Johnson',75000)
--Customer_lessthan_80000 table
create table Customer_lessthan_80000(
CustomerKey varchar(50),
FirstName varchar(20),
LastName varchar(20),
Salary int
)
--Customer_greaterthan_80000 table
Create table Customer_greaterthan_80000(
CustomerKey varchar(50),
FirstName varchar(20),
LastName varchar(20),
Salary int
)
Watch video SSIS Conditional Split | Conditional Split | MSBI Tutorials online without registration, duration hours minute second in high quality. This video was added by user Data Cafe 05 June 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 447 once and liked it 14 people.