Thank-you.
>>Hello,
>>
>>Yes, I have access to the SQL database and the view. I can go into SSMS and run the view and see the result in SSMS -- but that is on the client's SQL Server. I want to be able to run the view and put the data into a file so I can bring it back and put it on my SQL server so I can run the import utility and debug the code.
>>
>>Is there a SQL command that allows me to put the result in a file?
>>
>>Thanks,
>>
>>TFISHER
>>
>In SSMS you can output result of the query into a file. Alternatively, you can use Export option and run Import/Export wizard. Also, you can use SSIS.
Thanks,
TFISHER