What happened is that I found that when doing inserts on larger data sets, it would take a long time to complete the date and time joins. If I excluded this the data would be returned a lot quicker.   So my solution to the problem was to use the Cache Transform and then the Loopkup Transform in the SSIS…