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. ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
