Project2003 Interface from .Net

B

Billg_sd

I need to extract timesheet/project related data from MS Project 2003 Server
to generate custom DotNet based reports. I need to answer queries like:
"How much time has each employee spent on project X today?" Are there
interfaces or ibraries for this task that would be accessable from a .Net
application?

If not, is the SQL Server 2000 schema for MS Project 2003 documented
somewhere? I could write/call my own SQL stored procedures to perform such
queries.

Thank you,

--Billg_sd
 
R

Rod Gill

Hi,

Read svrdb.htm and prjdb.htm installed in one of Project's program folders.
The MSP_VIEW tables are designed as read-only sources for reports etc and
should fulfill your needs..
 

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 Benefits & Cost 2
need stored procedure which delete tasks from team members timeshe 1
delete 2007 Project(s) from MS SQL 2005 DB directly 5
How to change the timescale in MS Project Server web interface? 2
CONVERT MS PROJECT 2007 DATA INTO MS SQL SERVER 1
Project Server and timesheets 1
My Client is looking for a .Net Developer with Coding Experience... 0
SQL 2005: Missing SQL Server Management Console 1

Top