Creating an SSIS Package from Scratch
In this chapter, we'll work either from scratch or from the samples available with SQL Server. As with designing your first cube, developing SSIS packages requires that you use BIDS to create a new project.
Creating the Package Itself
To get started, in BIDS, select a project of type Business Intelligence Projects via File 
New Project and then a template of Integration Services Project. Leave your project name as Integration Services Project1, pick a directory location, and then click OK to create the project. ...
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.
