Using SSIS and Excel Services to Build a Lightweight Reporting Solution for Sharepoint-Based Applications (Part 3)

Part 1 – Introduction & Building the Back-End Reporting Database Part 2 – Developing SSIS Package to Import Data from Sharepoint List to Reporting Database Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package Part 4 – Building Reports and Publish on Sharepoint using Excel Services This part of the [...]

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for Sharepoint-Based Applications (Part 2)

Part 1 – Introduction & Building the Back-End Reporting Database Part 2 – Developing SSIS Package to Import Data from Sharepoint Lists to Reporting Database Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package Part 4 – Building and Publish Excel Reports on Sharepoint This is the second part of [...]

Using SSIS and Excel Services to Build a Lightweight Reporting Solution for Sharepoint-Based Applications (Part 1)

Part 1 – Introduction & Building the Back-End Reporting Database Part 2 – Developing SSIS Package to Import Data from Sharepoint Lists to Reporting Database Part 3 – Setup SQL Server Agent Job to periodically execute the SSIS Package Part 4 – Building and Publishing Excel Reports on Sharepoint Sharepoint is a rapid application development [...]

CEIP Data Collection Job Fails

CEIP Fails, It will look somthing like this Keep getting this error in the event viewer – how can I get rid of it once and for all? Log Name: Application Source: Microsoft-SharePoint Products-SharePoint Foundation Date: 03-08-2011 04:30:00 Event ID: 6398 Task Category: Timer Level: Critical Keywords: User: FarmAccount Computer: Description: The Execute method of [...]

Tips & Tricks – Problem Occurring When Setting Infopath Data Connection to Sharepoint Library

The problem occurred when I tried to set a data connection in an Infopath template to specify the document library on a Sharepoint site where the form will be submitted to. After I specified the Document Library and the file name and clicked the ‘Next’ button, a login window kept pop up and asked for [...]

The Lessons learned from Deploying Sharepoint 2010 Farms

1. Install Cumulative Update Package immediately after you have installed Sharepoint 2010 SP1. CU for Sharepoint Server 2010 http://support.microsoft.com/kb/2596505 CU for Sharepoint Foundation 2010 http://support.microsoft.com/kb/2596508 2. Grant the User Profile Synchronisation service account (e.g. SP_Sync) ‘Replicate Directory Changes’ permission on Domain or higher-level OU which contains the users you want to synchronise 3. Farm account [...]

Troubleshooting DPM Agent Issues

Troubleshooting DPM Agent problems can be tricky so heres a collection of ways to troubleshoot it. Technet Article for Troubleshooting DPM Agent Article on DPM Across TMG / WAN (Taken from MSDN Forums) Quote from Steve Light: DPM need to communicate via RPC/DCOM. Let’s test various connectivity between the DPM server and protected server. We’ll [...]