Import multiple Microsoft Project 2010 .MPP files into SQL Server 2008 R2 with SSIS

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

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 5:43am

Kosh2010

Updated 19-Jul-12 20:25pm

Tejas Vaishnav

v7

Add a Solution

3 solutions

Solution 2

In 2007 you could do this;

http://msdn.microsoft.com/en-us/library/bb968652(v=office.12).aspx[^]

Posted 22-Jul-12 4:21am

woutercx

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

Posted 7-Aug-12 6:24am

Kosh2010

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

woutercx · Accepted Answer · 2012-07-22T04:12:00

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[^]

Posted 22-Jul-12 4:12am

woutercx

Updated 22-Jul-12 4:17am

v2