Transfer data to MSP 2002

[Mads Groenfeldt]

Hi

I have some timesheet data in a SQL Server database that I would like
to transfer, on a regulary basis ( via a SQL Script ), to a MS Project
Server 2002.

The data consists of a project number, an assignment ID and a number
of hours. In which MSP 2002 tables should I insert these values? I
guess it would be the MSP_*_ASSIGNMENTS, but what about the data
integrity? Any pointers would be a great help..

Best regards

Mads

 

[Jonathan]

Project Server has a SDK which you can download from MS web site. The
SDK allow you to push info into Project Server.

 

[Mads Groenfeldt]

Hi

I am having troubles finding the methods I need in the SDK. I need to
iterate through all the projects on the Project Server, how can I do
that?

Would it be possible to just update the Actualwork column in
MSP_ASSIGNMENTS? Or would that invalidate the integrity?

- Mads