Conditional Split Transformation in SSIS with Example

By
roopesh.valluru
-
50
124111

Friends,

We come across many situations where we need to split data based on some conditions, like we mostly do in switch case statements or if else conditions in other programming languages and for doing the same we have Conditional Split task in SSIS. When ever you need to split the data coming from a source into many output paths based on some condition then CONDITIONAL SPLIT is the best bet.

It is used to transfer data to different output files or locations on satisfaction of the condition specified and content of the data. Here in this post lets see a simple example which explains about how to configure CONDITIONAL SPLIT transformation.

  • Start Integration Services Project template. On the package1.dtsx file add a data flow task as shown.

  • Edit the Data Flow task by selecting EDIT button on Right Click context menu. One Data Flow page is opened then drag and drop a Flat File source from toolbox to Data Flow pane.
  • Now Edit the Flat File source as shown below to set the connection properties.

  • When the popup opened, select NEW button to set the new Flat File connections to the FILE in which we have SAMPLE data. Now provide all the connection properties like path,delimiters ..

  • Select the columns page to check whether DATA is reading as expected or not.

  • If you see the Column3 in above screenshot, it is showing GENDER of Employees as either M or F. Now add a conditional split transformation to the data Flow pane and provide the output of Flat File source as input to Conditional Split transformation.
  • Now edit the Conditional Split to configure the same and write the below CONDITION under CONDITION column of the transformations and provide proper OUTPUT Name as shown below.

 

For filtering MALE Employees – UPPER([Column 3]) == “M”

For filtering FEMALE Employees -UPPER([Column 3]) == “F”

 

  • Now we need to add two Flat File Destination components and we can attach the conditional task output to them using the green arrow line. When ever you drag and drop on destination then it will ask for WHICK output we need to set as source as shown below and select the correct one for each destination.
  • I selected Males as Input to First Flat File destination and Females as input to the second destination file. (I know i have used Males and Females which is WRONG but what to do, i did this mistake and captured Screenshots .. Please adjust .. :))

 

  • Configure the Flat file destination for Males and Females data . Double click on the component, Click on new, Select the format as delimited, Click OK. Set the output file path and then click on Mapping tab and finally click OK. Repeat the same for the second file too.

  • After configuring Click OK.

 

  • Now execute the package and see the output. You can see the data moved to both the files by applying the condition given .. i.e Male Employees to ONE FILE and Female Employees to ANOTHER FILE.

This is it .. As simple as this .. You can easily split the data coming from input to many outputs based on condition. You can also use functions while providing the condition and you can find all the functions on the RIGHT TOP side on Conditional Split Transformation. Also remember that you can use VARIABLE values as part of SPLIT Condition. Hope you understood it .. Enjoy Coding !!

Regards,
Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

50 COMMENTS

  1. Я здесь случайно, но специально зарегистрировался, чтобы поучаствовать в обсуждении.
    обычно, https://walkingtourinnewbraunfels.com/home/appleappstore/ vpn – это более дорогой вариант. Рассмотрим основные различия vpn и прокси-сервера. Обычно при осуществлении просмотра веб-страниц компьютер подключается соответственно к веб-сайту и начинает загружать страницы для чтения – это весьма простой процедура.

  6. Отечественный этношоп НашаМебель предлагает широченный гарнитур кухонь, что посодействуют создать устроенность равно благоустроенность на вашем доме https://notahye4kuhnishki.ru/.

  8. Выше- интернет-магазин “Мебель-шмммммммебель” призывает широченный номенклатура мебели для кухонь. У нас ваша милость найдете шиздец нужное для произведения приятного и высокофункционального внутреннего убранства https://www.tyfapao6kuhnishki.ru.

  12. JILI SLOT GAMES: Sự Lựa Chọn Hàng Đầu Cho Các Tín Đồ Casino Trực Tuyến

    JILI Casino là một nhà phát hành game nổi tiếng với nhiều năm kinh nghiệm trong ngành công nghiệp giải trí trực tuyến. Tại JILI, chúng tôi cam kết mang đến cho người chơi những trải nghiệm độc đáo và đẳng cấp, thông qua việc đổi mới không ngừng và cải thiện chất lượng từng sản phẩm. Những giá trị cốt lõi của chúng tôi không chỉ dừng lại ở việc tạo ra các trò chơi xuất sắc, mà còn tập trung vào việc cung cấp các tính năng vượt trội để đáp ứng nhu cầu của người chơi trên toàn cầu.

    Sự Đa Dạng Trong Các Trò Chơi Slot
    JILI nổi tiếng với loạt trò chơi slot đa dạng và hấp dẫn. Từ các slot game cổ điển đến những trò chơi với giao diện hiện đại và tính năng độc đáo, JILI Slot luôn đem đến cho người chơi những phút giây giải trí tuyệt vời. Các trò chơi được thiết kế với đồ họa sống động, âm thanh chân thực và những vòng quay thú vị, đảm bảo rằng người chơi sẽ luôn bị cuốn hút.

    Ưu Điểm Nổi Bật Của JILI Casino
    Đổi mới và sáng tạo: Mỗi trò chơi tại JILI Casino đều mang đến sự mới mẻ với lối chơi hấp dẫn và giao diện bắt mắt.
    Chất lượng cao: JILI không ngừng cải tiến để đảm bảo mỗi sản phẩm đều đạt chất lượng tốt nhất, từ trải nghiệm người chơi đến tính năng trò chơi.
    Nền tảng đa dạng: JILI Casino cung cấp nhiều loại game khác nhau, từ slot, bắn cá đến các trò chơi truyền thống, phù hợp với mọi sở thích của người chơi.
    Chương Trình Khuyến Mại JILI
    JILI Casino không chỉ nổi bật với chất lượng game mà còn thu hút người chơi bởi các chương trình khuyến mại hấp dẫn. Người chơi có thể tham gia vào nhiều sự kiện, từ khuyến mãi nạp tiền, hoàn trả đến các chương trình tri ân dành riêng cho thành viên VIP. Những ưu đãi này không chỉ tăng cơ hội chiến thắng mà còn mang lại giá trị cộng thêm cho người chơi.

    Nổ Hủ City Và Các Trò Chơi Hấp Dẫn Khác
    JILI không chỉ có slot games mà còn cung cấp nhiều thể loại game đa dạng khác như bắn cá, bài và nhiều trò chơi giải trí khác. Nổi bật trong số đó là Nổ Hủ City – nơi người chơi có thể thử vận may và giành được những giải thưởng lớn. Sự kết hợp giữa lối chơi dễ hiểu và các tính năng độc đáo của Nổ Hủ City chắc chắn sẽ mang lại những khoảnh khắc giải trí đầy thú vị.

    Tham Gia JILI Casino Ngay Hôm Nay
    Với sự đa dạng về trò chơi, các tính năng vượt trội và những chương trình khuyến mại hấp dẫn, JILI Casino là sự lựa chọn không thể bỏ qua cho những ai yêu thích trò chơi trực tuyến. Hãy truy cập trang web chính thức của JILI ngay hôm nay để trải nghiệm thế giới giải trí không giới hạn và giành lấy những phần thưởng hấp dẫn từ các trò chơi của chúng tôi!

  13. Фотофабрика кашеварных гарнитуров в С-петербурге – это ваш фундаментальный участник в образовании кухонных интерьеров. Наша сестра специализируемся на разработке, производстве также установке высококачественных кухонных гарнитуров, коие соединяют на себе язык, работоспособность также долговечность. Наша представительство – обеспечить покупателям индивидуальные ответы, организованные с учётом их пожеланий а также надобностей, чтоб всякая шакша остановилась уютным (а) также удобным местностью чтобы житья равным образом творчества http://tivokya0kuhnishki.ru.

  18. Наша компания «Сайт числом мебели для кухни» захватывается созданием равно продажей качественной кухонной мебели. Автор делаем отличное предложение широченный ассортимент продукта, яже дает ответ самым современным шаблонам (а) также направленностям дизайна http://sufebey8kuhnishki.ru.

  20. Наша юкос «Сайт числом мебели для кухни» увлекается основанием и еще реализацией лучшей кухонной мебели. Мы делаем отличное предложение широкий номенклатура продукта, яже соответствует самым прогрессивным стандартам и еще направленностям дизайна https://sufebey8kuhnishki.ru.

  21. Отечественный этношоп НашаМебель делает отличное предложение широченный круг кухонь, какие посодействуют сделать устроенность равным образом уют в вашем доме https://www.notahye4kuhnishki.ru.

  22. Фабрика кухонных гарнитуров в течение Санкт-петербурге – этто ваш фундаментальный партнер в течение создании кашеварных интерьеров. Мы работаем на разработке, фабрике равным образом аппарате первоклассных кашеварных гарнитуров, которые сочетают в течение себя стиль, функциональность равно долговечность. Наша миссия – отдать покупателям отдельные заключения, построенные из учётом их пожеланий да необходимостей, чтобы каждая шакша застопорилась приятным и удобным постом для века (а) также творчества https://www.tivokya0kuhnishki.ru/.

  25. Наш интернет-магазин “Мебель-шмммммммебель” зовет широкий ассортимент мебели чтобы кухонь. ЯЗЫК нас вы обнаружите все нужное чтобы образования приятного также функционального интерьера https://tyfapao6kuhnishki.ru.

  26. Я Вам очень благодарен. Огромное спасибо.
    Онлайн https://1go-casino-fibt3.xyz/ Пин Ап компенсирует собственным клиентам до 10% от ставки проигрыша за прошлую неделю. Но успешность гемблинга во многом зависит от грамотного выбора беттинг платформы.

  28. Разработка дизайн проекта интерьера квартиры, дома, офиса, ресторана, кафе, магазина в Санкт-Петербурге и других городах России. Выполнение проекта в стиле скандинавский. Выполнение чертежей с выбором отделочных материалов, а также ремонт под ключ ресторанов
    проект дома цена
    проект коттеджа
    дизайн проект дома

    дизайн проект интерьера

  29. Наша юкос «Фотосайт числом мебели чтобы кухни» захватывается формированием а также реализацией лучшей кухонной мебели. Я делаем отличное предложение широченный асортимент продукта, который отзывается наиболее сегодняшним трафаретам и тенденциям дизайна http://www.sufebey8kuhnishki.ru.

  30. Introduction
    In a society that changes at lightning speed, the capacity to develop isn’t just helpful—it’s crucial. Whether you’re an entrepreneur, a business leader, or a developer, staying in the lead requires an innovative mindset. This blog post will investigate the notion of innovation, uncovering what it takes to be a genuine innovator and why it’s more critical now than ever. You’ll learn traits that define successful innovators, find inspiring case studies, and gain usable strategies for fostering your own creative thinking.
    What is Innovation and Why Does it Matter?
    Innovation is more than just a term; it’s the lifeblood of advancement. It requires creating new ideas or upgrading existing ones, leading to concrete benefits. In today’s fast-paced environment, businesses must innovate to thrive and prosper. Innovation propels efficiency, enhances customer interaction, and opens new revenue streams. Without it, inactivity is certain.
    Traits of a True Innovator
    Creativity
    https://about.me/rileyreesepurdue
    At the heart of innovation is creativity. This quality allows individuals to think beyond the box, generating distinct solutions to difficult problems. Creative thinking can be cultivated by exposing oneself to diverse perspectives and backgrounds.
    Adaptability
    In a swiftly changing world, an innovator must be adaptable. Being able to change when faced with new obstacles or opportunities is crucial. Adaptability ensures that you can evolve alongside market shifts and digital advancements.
    Risk-Taking
    Innovation often requires venturing into the uncertain. True innovators are willing to take measured risks. They know that failure is a part of the process and use it as a growth tool to improve their ideas.
    Case Studies of Successful Innovators
    Elon Musk
    Elon Musk’s groundbreaking ventures, from Tesla to SpaceX, have revolutionized industries. His preparedness to tackle massive technological challenges and disrupt established markets showcases the power of a bold vision.
    Sara Blakely
    Sara Blakely, the entrepreneur of Spanx, turned a straightforward idea into a billion-dollar business. Her innovation in the clothing industry demonstrates how solving everyday challenges can lead to remarkable success.
    Steve Jobs
    Steve Jobs’ persistent pursuit of innovation transformed Apple into a international tech giant. His focus on design and user experience set new benchmarks for the industry, proving that innovation can be a key advantage.
    Fostering an Innovative Mindset
    Encourage a Culture of Openness
    Creating an atmosphere where new ideas are embraced and valued is essential. Organizations should encourage employees to share their ideas without fear of judgment. This openness fosters cooperation and sparks creativity.
    Learn from Failure
    Failure is an unavoidable part of the innovation path. Instead of avoiding it, innovators should view failure as an opportunity to learn and grow. Analyzing what went wrong and why can provide valuable lessons for future endeavors.
    Embrace New Technologies
    Tech advancements offer endless potential for innovation. Staying informed with the latest advancements and tools can provide a competitive edge. Whether it’s AI, blockchain, or IoT, leveraging new technologies can result in significant breakthroughs.
    The Role of Innovation in Business Growth
    Driving Efficiency
    Innovative methods can streamline operations, reducing costs and increasing efficiency. Automation and digital transformation are examples of how businesses can innovate to enhance productivity.
    Enhancing Customer Experience
    Innovation can significantly improve customer interaction. By understanding customer demands and developing customized solutions, businesses can foster loyalty and drive growth. Customized services and innovative products can set a company apart from its rivals.
    Opening New Revenue Streams
    Innovative thinking can uncover new enterprise opportunities. Diversifying product lines, entering new fields, or developing unique services can open new revenue streams. This expansion mitigates risk and promotes sustainable growth.
    Conclusion
    Innovation is the driving force behind achievement in today’s ever-changing world. By understanding the characteristics of true innovators, learning from effective case studies, and fostering an innovative mindset, you can unlock your inventive potential. Remember, innovation isn’t just about groundbreaking inventions; it’s about making constant improvements that add value. Whether you’re leading a team or pursuing solo projects, the ability to innovate will set you apart and drive your success. Now, it’s time to put these insights into action and start your own original journey.

  32. Отечественный интернет-магазин “Мебель-шмммммммебель” зовет широченный запас мебели для кухонь. У нас ваша милость обнаружите шиздец необходимое для создания уютного также высокофункционального экстерьера https://tyfapao6kuhnishki.ru.

  35. Prologue
    In a realm that transforms at rapid speed, the ability to create isn’t just beneficial—it’s vital. Whether you’re an founder, a corporate leader, or a coder, staying ahead requires an creative mindset. This blog post will explore the concept of innovation, uncovering what it takes to be a true innovator and why it’s more significant now than ever. You’ll learn qualities that characterize successful innovators, discover motivating case studies, and gain realistic strategies for fostering your own original thinking.
    What is Innovation and Why Does it Matter?
    Innovation is more than just a term; it’s the core of advancement. It entails creating new ideas or improving existing ones, leading to concrete benefits. In today’s quick environment, businesses must innovate to exist and flourish. Innovation fuels productivity, enhances customer interaction, and opens new earning streams. Without it, inactivity is certain.
    Traits of a True Innovator
    Creativity
    https://open.spotify.com/user/315dinldrfeteavaw5odm2f4cq6i
    At the core of innovation is creativity. This quality allows individuals to think beyond the box, generating distinct solutions to complex problems. Innovative thinking can be nurtured by exposing oneself to diverse perspectives and experiences.
    Adaptability
    In a rapidly changing world, an innovator must be flexible. Being able to pivot when faced with new challenges or opportunities is essential. Adaptability assures that you can evolve alongside market trends and digital advancements.
    Risk-Taking
    Innovation often involves venturing into the unexplored. True innovators are willing to take calculated risks. They understand that failure is a part of the process and use it as a educational tool to enhance their ideas.
    Case Studies of Successful Innovators
    Elon Musk
    Elon Musk’s creative ventures, from Tesla to SpaceX, have changed industries. His willingness to tackle huge technological challenges and alter established markets showcases the strength of a bold vision.
    Sara Blakely
    Sara Blakely, the creator of Spanx, turned a basic idea into a billion-dollar business. Her innovation in the fashion industry demonstrates how solving everyday problems can lead to exceptional success.
    Steve Jobs
    Steve Jobs’ relentless pursuit of innovation transformed Apple into a international tech giant. His focus on appearance and user interaction set new standards for the industry, proving that innovation can be a key advantage.
    Fostering an Innovative Mindset
    Encourage a Culture of Openness
    Creating an environment where new ideas are accepted and valued is crucial. Organizations should support employees to share their ideas without fear of judgment. This openness fosters teamwork and sparks creativity.
    Learn from Failure
    Failure is an unavoidable part of the innovation path. Instead of avoiding it, innovators should view failure as an opportunity to learn and grow. Reviewing what went wrong and why can provide valuable insights for future efforts.
    Embrace New Technologies
    Tech advancements offer endless possibilities for innovation. Staying current with the latest trends and tools can provide a competitive edge. Whether it’s AI, blockchain, or IoT, leveraging new technologies can result in significant breakthroughs.
    The Role of Innovation in Business Growth
    Driving Efficiency
    Innovative methods can streamline operations, reducing costs and increasing efficiency. Automation and digital change are instances of how businesses can innovate to enhance productivity.
    Enhancing Customer Experience
    Innovation can significantly improve customer interaction. By understanding customer demands and developing customized solutions, businesses can foster loyalty and encourage growth. Customized services and innovative products can set a company apart from its peers.
    Opening New Revenue Streams
    Innovative thinking can uncover new enterprise opportunities. Diversifying product lines, entering new fields, or developing unique services can open new revenue streams. This expansion mitigates risk and promotes sustainable growth.
    Conclusion
    Innovation is the driving force behind progress in today’s fluid world. By understanding the traits of true innovators, learning from successful case studies, and fostering an innovative mindset, you can unlock your inventive potential. Remember, innovation isn’t just about groundbreaking inventions; it’s about making ongoing improvements that add value. Whether you’re leading a team or pursuing individual projects, the ability to innovate will set you apart and drive your success. Now, it’s time to put these insights into action and start your own original journey.

  36. Наша компания «Фотосайт по мебели для кухни» воспламеняется созданием равно продажей лучшей кашеварной мебели. Мы делаем отличное предложение широкий коллекция продукта, яже отвечает наиболее сегодняшним трафаретам а также тенденциям дизайна http://sufebey8kuhnishki.ru.

  37. Фабрика кухонных гарнитуров на С-петербурге – этто ваш надежный партнер в течение произведении кашеварных интерьеров. Автор этих строк работаем сверху исследованию, изготовлении а также аппарате первоклассных кашеварных гарнитуров, коим соединяют в течение себя стиль, функциональность также долговечность. Наша поручение – передать посетителям индивидуальные решения, сформированные кот учётом ихний пожеланий и необходимостей, чтобы каждая кухня встала уютным и спокойным помещением для живота и еще творчества https://tivokya0kuhnishki.ru/.

  38. Отечественный инет-магазин “Мебель-шмммммммебель” делает отличное предложение широченный инвентарь мебели чтобы кухонь. ЯЗЫК нас вы урвете шиздец необходимое чтобы произведения приятного и еще функционального интерьера https://www.tyfapao6kuhnishki.ru.

  40. 7 simple secrets to eating the Mediterranean way
    кракен вход
    What if “diet” wasn’t a dirty word?

    During Suzy Karadsheh’s childhood in Port Said, Egypt, diet culture was nonexistent.

    “My parents emphasized joy at the table, rather than anything else,” Karadsheh said. “I grew up with Mediterranean lifestyle principles that celebrate eating with the seasons, eating mostly whole foods and above all else, sharing.”

    But when Karadsheh moved to the United States at age 16, she witnessed people doing detoxes or restricting certain food groups or ingredients. Surrounded by that narrative and an abundance of new foods in her college dining hall, she says she “gained the freshman 31 instead of the freshman 15.” When she returned home to Egypt that summer, “I eased back into eating the Mediterranean food that I grew up with. During the span of about two months, I shed all of that weight without thinking I was ever on a diet.”
    To help invite joy back to the table for others — and to keep her family’s culinary heritage alive for her two daughters (now 14 and 22) — Atlanta-based Karadsheh launched The Mediterranean Dish food blog 10 years ago. Quickly, her table started getting filled with more than just her friends and family.

    “I started receiving emails from folks whose doctors had prescribed the Mediterranean diet and were seeking approachable recipes,” Karadsheh said. The plant-based eating lifestyle, often rated the world’s best diet, can reduce the risk for diabetes, high cholesterol, dementia, memory loss and depression, according to research. What’s more, the meal plan has been linked to stronger bones, a healthier heart and longer life.

    Preparing meals the Mediterranean way, according to Karadsheh, can help you “eat well and live joyfully. To us, ‘diet’ doesn’t mean a list of ‘eat this’ and ‘don’t eat that.’” Instead of omission, Karadsheh focuses on abundance, asking herself, “what can I add to my life through this way of living? More whole foods, vegetables, grains, legumes? Naturally, when you add these good-for-you ingredients, you eat less of what’s not as health-promoting,” she told CNN.

  41. Наша юкос «Сайт по мебели для кухни» занимается твореньем равным образом продажей качественной кашеварной мебели. Автор этих строк делаем отличное предложение широченный комплект продукции, яже дает ответ наиболее сегодняшним эталонам и направленностям дизайна http://www.sufebey8kuhnishki.ru/.

  45. Фотофабрика кашеварных гарнитуров в течение Санкт-петербурге – это ваш фундаментальный участник на создании кухонных интерьеров. Ты да я специализируемся сверху разработке, фабрике и аппарате первоклассных кухонных гарнитуров, кои соединяют в течение себя язык, работоспособность и долговечность. Наша миссия – позволить посетителям личные резолюции, разработанные один-два учётом их пожеланий и надобностей, чтоб каждая кухня остановилась приятным и удобным должностью для жизни а также творчества http://www.tivokya0kuhnishki.ru.

  46. Наша компания «Фотосайт по мебели для кухни» воспламеняется формированием (а) также перепродажей качественной кухонной мебели. Мы делаем отличное предложение широченный ассортимент продукта, яже говорит самым передовым трафаретам да тенденциям дизайна http://www.sufebey8kuhnishki.ru.

  47. Отечественный интернет-магазин “Мебель-шмммммммебель” предлагает широкий комплект мебели чтобы кухонь. ЯЗЫК нас ваша милость вырвете все необходимое для создания уютного равным образом высокофункционального внутреннего убранства http://www.tyfapao6kuhnishki.ru.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

ninety three − 87 =