Privileges needed to export view to txt?

[schusser]

I have created a view and need to export it to a text file to send to another application. When I try to use DTS, my views do not appear on the selection dropdown, only my tables.

Is there something that needs to be changed in my permissions that will allow views to be shown and selected?

Thanks in advance...

 

[NoCoolHandle]

No, just use a QUERY instead of the drop down list as the source (I think clicking the build button will show views as well as tables if you are having a hard time remembering the name of the view you want to use)

Rob