I used to loathe building data sources with temp tables. That is until I learned how to 'trick' SSIS with a simple work around. Here is our data flow. Here is the source query. The use of a temp table…