A package is the object that implements Integration Services functionality to extract, transform, and load data. You create a package by using the SSIS Designer in BI Development Studio. You can also create a package by running the SQL Server Import and Export Wizard or the Integration Services Connections Project Wizard. For more information, see Designing Packages in Business Intelligence Development Studio and Creating a Package by Running a Wizard.
A basic package includes the following elements:
For an example of how to create a basic package, see Lesson 1: Creating the Project and Basic Package.
For a video that demonstrates how to create a basic package, see Creating a Basic Package (SQL Server Video).