Exploring Business Intelligence Development StudioSolution ExplorerDocking Utility WindowsExploring an SSIS Project in BIDSOpen SSIS Sample SolutionView the ScrapReason data source view in the Data Source view designerView the CreateLists package in the package designerOpen the Data Flow Task – Employee ListExplore the connection managersOpen the OLE DB Source – Employee Query taskOpen the Derived Column – FullName taskOpen the Sort – Department Shift Employee taskOpen the Flat File Destination – Employees CSV taskView the final outputExecute the CreateLists packageView Employees, ScrappedProducts, and customer records files in the data folderReview the ImportCustomers packageExcute the ImportCustomers packageUsing the SSIS Import and Export WizardCreating Tables in a New DatabaseRun the wizard in BIDSReview the is2005sbs database by using Management StudioCreate the QuickStart solution to contain the QuickStartIS SSIS projectImport tables into a new QuickStartODS database with a new packageReviewing Package ElementsReviewing a Package Created Using the Import and Export WizardReview the preparation SQL taskReview the data flow taskTesting a PackageExecuting the Package in the DesignerExecute the QuickStartIS.dtsx packageStop debugging and close the package designerReview the QuickStartODS database tables by using SSMSChapter 2 Quick Reference