Use SQL DMO to generate a text file in the C:\temp folder. The file should contain data from the authors table in the pubs database.
Use a function to generate this file.
Public Function DatatoFile() as string

I managed to accomplish this task using Enterprise Manager, but I the question asked me specifically to accomplish this using SQL DMO.

I am not sure how to do this.

Can anyone shed some light on the subject.

Thanks

Alvin