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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Server 2007 and SSRS 2005 integration: issue withauthentication when running to the reports 3
CONVERT MS PROJECT 2007 DATA INTO MS SQL SERVER 1
Opening a Project in SQL Server Using VBA 8
Which database does the Resource Center get it's data from 2
Sync between PWA-view data and data in the project data base 1
Olap data views 3
Installing Project Server and Project Portfolio within a MOSS farm 1
Project 2007 and Project Portfolio 2007 on a MOSS 2007 farm 1

Top