Home Forums Data Warehousing Integration Services How do I do an inner join where the join conditions are not equal in SSIS? RE: How do I do an inner join where the join conditions are not equal in SSIS?

  • August 26, 2013 at 2:06 am

    #1644814

    Phil Parkin (8/25/2013)

    That may be so, but doing joins using the SQL Server engine is much faster than doing them in SSIS. So it may feel like a workaround, but perhaps if you instead consider it as a performance optimisation things won't seem so bad 🙂

    If the data is already sorted, SSIS isn't necessarily slower for large data sets.

    If the data is sorted. 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP