O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building Basic SSIS Packages

As with other types of BI design, such as cubes, you'll open BIDS to begin creating an SSIS package. BIDS functionality is accessed via a set of included BI template types that are available inside of the Visual Studio (VS) interface. BI objects are created using the BIDS templates, including templates to create SSAS databases (cubes, dimensions, and data mining structures and models), SSIS projects (SSIS packages), and SSRS reports and report models. Templates consist of starter folders and files that are specific to the project type selected. To start working in BIDS, you open it from the Start menu, click File New Project, and then select the appropriate project type from the templates of type Business Intelligence. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required