Thanks for the help i noticed that part 🙂

Exe pulls connect to exchange server and pull all the appointments setup for specific outlook groups and insert data into SQL table.

Thanks for the hint i will look into this.

thanks this approach will work perfectly 🙂

Thanks for providing the solution.

will keep in mind next time how to post questions on a forum to get the best help.

thanks Jason ... its working 🙂

will keep you posted about the results i am getting once i will start loading against DW.

Hi Jason

i tried it but its missing one row for product A Location 1 for 2015-11-29

And for location for missing week its showing null , how to display...

Thanks Jason , i will try this and let you know about the results

🙂