This content has been marked as final. Show 4 replies
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???