Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Project Server Custom/Enterprise Fields from SQL

Author  Topic 

BrandonSi
Starting Member

1 Post

Posted - 2009-01-20 : 14:44:39
Hi there, I hope this is in the right section, if not I apologize.

I've been tasked with ensuring that our custom/enterprise fields in MS Project Server 2007 are populated from certain databases to ensure consistency in our projects. For example, we have a custom field for 'Department' that all Projects need to have set. Currently this drop-down box is populated by data that was at one time entered by hand.

I've done plenty of research, but I'm still lost as to how I would go about getting Project Server to populate that field by using a query.. For example, just 'select dept_name from department'.

It's starting to look like I need to write something in Visual Studio to interface with the PSI web services?

Again, completely lost.. Any help or just a high level overview would be greatly appreciated.
   

- Advertisement -