I thought i'd found the perfect solution:
EXEC sp_addlinkedserver TextOut,
DELETE FROM TextOut...table1#csv
select top 10 *
EXEC sp_dropserver 'TextOut'
But it's not supported in 64bit SQL Server 2005!
We want to keep the server secure so don't want to enable sp_cmdshell
The code is being executed from a plain .asp page on a different webserver so BCP is out of the question
Do i have any other options?
My SQL query is simply SELECT * FROM myView. Occasionaly i will alter the structure of myView. If i need to use a SSIS package, is there a way to avoid having to re-jig the package everytime i alter myView? At the moment it gets rather upset and needs me to recreate the steps, remap all columns etc