|
PerformancePoint Planning Server SQL Server Integration Services (SSIS) Starter Kit |
Step-by-step directions detailing the recommended data import package steps in a typical PerformancePoint Planning Server application
This document includes step-by-step directions detailing the recommended data import package steps in a typical PerformancePoint Planning Server application. It provides a starter Visual Studio 2005 Business Intelligence Development Studio (BIDS) 2005 solution including a SQL Server Integration Services (SSIS) project with two files which can be used as the starting point for Dimension and Fact data load packages. The Dimension data is set up to source from an Excel file, and the fact data package sources from a SQL Server database called CustomerDataScrubbed. BizCorp is a sample Performance Point Planning application used as the destination. You must change your database connections, package variables and configuration file settings to be appropriate for the packages to work in your environment. Those steps are covered by this document.
Files
|
Status: DeletedThis download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to April 2019. |
| Files |
|---|
SSISStarterKit.zip
|
System Requirements
Operating Systems: Windows Vista, Windows XP
- A PerformancePoint Planning application which contains dimensions, including a time dimension and at least one model site
- Visual Studio 2005/Business Intelligence Development Studio (BIDS) (installed through SQL Server 2005 tools)
- SQL Server 2005 SP2
- PerformancePoint Planning Server Business Modeler
- An account with Data Modeler permissions on a PerformancePoint Planning Server Application that also has Administrator permissions in the development environment
- Knowledge of how to create and deploy a SQL Server Integration Services (SSIS) package
To read the "Starter Project Instructions" paper, you must have Microsoft Office Word 2007. You can also use Office Word 2003 or Word XP and the Microsoft Office Compatibility Pack.
Installation Instructions
Click Download, and then save the archive file to your computer. Open the "Starter Project Instructions.docx" file in Word to read complete instructions about the solution.