Extracting Project and Resource data (flat) file using SQL Mgmt St

M

MSPLearner

I have the SQL code created to extract some Project & Resource data from
Project Server 2007 Reporting DB. My question is how to extend this code to
write a file out to disk via SQL Mgmt Studio?

Appreciate any help.

Dinesh
 
M

MSPLearner

Thanks Rod,

Actually I need to send this file to another system. The extract would have
to run periodically on the server.

MSPLearner
 
R

Rod Gill

Yep, just refresh the query then save again. For an automatic run use some
VBA to do the same (you can record the code).

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
Top