Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server-2008 SSIS , +
Hello,
I need help in using SSIS to import multiple Microsoft Project 2010 .MPP files posted on a Sharepoint site into a SQL Server 2008 R2 database I'm developing. Unfortunately, there is no backend database applied by Microsoft Project. Otherwise, I would connect to that directly.
Can somebody provide me with the steps and perhaps sample code for achieving this goal? I have run many searches and have found nothing up to date with the details required and SSIS does not contain a control flow task specific to Microsoft Project.
 
After extracting and importing into the database the following fields from each Microsoft Project file, my objective is to query this data against that extracted from other sources (other databases, Excel spreadsheets, and flat files) to generate automated reports with SSRS. This part I can handle, but I first need to figure out how to automate the importing of Microsoft Project files.
 
Name
Active
Division
Region
Scheduled_by_Element
Project_ID
Project_Iteration
Watch_Status
Actual_Start
Actual_Finish
Start_Date
Finish_Date
Baseline_Start
Baseline_Finish
Percent_Complete
Duration
Outline_Level
WBS
Milestone
Rollup
Notes
Augment_Phase
 
If coding is required, I have experience with both C# and VB. If Microsoft Project needs to be installed on the database server in order for the code to work, then this is not a problem.
 
The best working examples I've found so far are detailed in the following links, but the coding is no longer compatible with the before mentioned tools I'm using.
 
http://www.msproject.com/OLEDB.htm[^]
 
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_CSharp/Q_24846116.html[^]
 
Thanks
Posted 18-Jul-12 6:43am
Edited 19-Jul-12 21:25pm
v7
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

If you would be able to save the project files as XML format (I see that .mpp is binary), that would be a whole lot easier.. You could call the SaveAs function from VBA. Here's an example I think.
 
http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/f1895801-5b2b-4aba-be41-d529f796ae87[^]
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

woutercx,
Thank you very much for the suggestions. The solution I ended up applying is similar to that in your first post. I reverse-engineered the Windows application discussed in the following Code Project link and modified it into a console application that converted the export to a CSV format.
 
Excel Report from Microsoft Project[^]
 
As soon as the console application is more fully tested, I'll post that on Code Project and share credit with the zam664, who authored the originating code.
 
Thanks,
Kosh2010
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 350
1 Jochen Arndt 190
2 Richard MacCutchan 135
3 Sergey Alexandrovich Kryukov 130
4 DamithSL 105
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,310


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 7 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100