That looks like a huge catch-all query, so I'm really not surprised it's running poorly. You'll likely want to change this to dynamic SQL. Gail wrote a great article on...

That query you given won't work as it is, as one it contains at least one syntax error.

What is the actual results you want here? I think, if...

I'm not sure I follow your sample data I'm afraid; is that 2 tables or 3? What is the relationship between the 2/3 tables? What is the expected results here...

Think one of my best days was in my first full cycle DR test and everything from the DB side of things was up and running by the end of...

You could probably achieve this with a Script task, yes; you could certainly do it with a Script Transformation (but those were introduced with SSDT 2012). Your post, however, seems...

You could, if you wanted, create the table in tempdb. Although it's not a true "temporary table", it will still only persist for as long as the server is running....