4 Replies Latest reply: Aug 24, 2016 7:53 AM by josh flory RSS

    Use custom SQL in Add Data?

      I want to just paste an SQL script into the Add Data area.


      I don't want to go picking a bunch of tables by hand, I just want to paste in my query.


      I can do that in the LOAD script area...but if I do that I can't manipulate table relationships etc... in the add data area (associations) or whatever.



      Is there not anyway to just paste a query into the tool and have it use that result?


      Am I forced to create views on my SQL server and then map to the views in Add Data???