Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Intermediate SSIS > Reviewing the Included Samples Packages

Reviewing the Included Samples Packages

Now that we've completed our tour of the BIDS environment and the common areas, we'll start working through the sample packages. These packages are located by default at C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services. We'll use these packages as a platform to build our understanding of two of the core parts of the SSIS design interface: using the control flow tasks and data flow transformation.

The first package we'll start with is the Execute SQL Statements in Loop sample. To open this package in BIDS, locate the samples folder (C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services), then double-click the ExecuteSqlStatementsInLoop.sln file. This opens the SSIS solution (and project) file in BIDS. Next, double-click the same file name under the packages node in Solution Explorer (or ExecuteSQLStatementsInLoop.dtsx). This opens the package to the Control Flow design surface and is shown in Figure 8-8.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint