How to Perform Cross Join in Data Flow Task in SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to answer SQL Server integration Services (SSIS ) Interview Question
"In Merge Join Transformation, we can use Inner Join, Left Join and Full Outer Join. If I have to use Cross Join, which transformation would I use?"

We will learn following items in this video

  1. What is Cross Join
  2. What is Inner join 
  3. How to use Merge Join transformation in SSIS Package
  4. How to use Merge Join Transformation in Data Flow Task to perform Cross Join
  5. How to use Sort Transformation in SSIS Package
  6. How to use Multicast Transformation in SSIS Package



How to Perform Cross Join in Data Flow Task in SSIS Package - SQL Server Integration Services(SSIS) Tutorial