I have a query that runs beautifully in SQL. I tried using this same query that pulls from multiple tables as my OLE DB Source. (I get 10011 rows in SQL) I then added a Destination source of csv and I got the message that 0 records were added to my file (but I do see headers). I added a data viewer between the steps but not getting any results. Any thoughts? I have been googling for days and I am not making any progress.
I am sure that this is a very basic question, but I have been struggling for days!
Screen Shot 1 
Here are my screen shots...
