Professional SQL Server™ 2005 Integration Services

2.4. Creating Your First Package

Before you jump into the fundamentals of the toolset, you should exercise some of the BIDS features by creating a very basic package. If you don't understand some of this, don't worry yet. It will make much more sense later in this chapter and in Chapter 3. This quick example will show you how to configure a task and how to chain tasks together with precedence constraints.

Start by opening BIDS by selecting Start Programs Microsoft SQL Server 2005 SQL Server Business Intelligence Development Studio. Once BIDS is open, select New Project from the File menu. Under the Business Intelligence Project Type on the left, select Integration Services Project. Call the project "Basic Package" for the Name option, and then click OK.

In the Solution Explorer to the right of BIDS, you'll see that an empty package called Package1.dtsx was created. On the left of BIDS is your Toolbox, which contains all of the work items that you can accomplish in whatever tab you're in. In the Toolbox, drag the Execute Process task over to the empty design pane in the middle. Double-click ...