Finish column imported from MS SQL server RRS feed

  • Question

  • I have a database on MS SQL server 2008R2. There are Start and Finish colums. Their format is VARCHAR, mm:ss. I can import these columns into MS Project2010 by ODBC and mapping. Start column for task is OK. But Finish column has the same value as start column in some cases. For example, in SQL table I have Start 13.10.2014 6:35 and Finish 13.10.2014 7:35. But MS project display 13.10.2014 6:35 and 13.10.2014 6:35. It means that duration is computed bad. I do not know the reason for this behaviour. Can anybody help me?

    Monday, October 13, 2014 12:14 PM

All replies

  • Tomas,

    Since Project is set up to calculate the schedule, it works much better if the user inputs a start date and a duration. Project will then calculate the finish date. I suggest you import the start date and duration.


    Monday, October 13, 2014 2:36 PM
  • John,

    thank you for your answer. You are right. We have special software which creates time schedule for our production department. The results are saved into sql table. We use ms project only to display these results.

    I found the solution. New file uses global template global.mpt. I edit default calendar for this template. Default calendar has working time 9-13 and 14-18. I substitute working time by 00:00-00:00. It works now well.

    Tuesday, October 14, 2014 12:43 PM