Wednesday, November 24, 2010

creating an ssis package in BIDS

Creating a Package:

The Import and Export Wizard is easy to use, but it only taps a small part of the functionality of SSIS. To really appreciate the full power of SSIS, you’ll need to use BIDS to build an SSIS package. A package is a collection of SSIS objects including:

  • Connections to data sources.
  • Data flows, which include the sources and destinations that extract and load data, the transformations that modify and extend data, and the paths that link sources, transformations, and destinations.
  • Control flows, which include tasks and containers that execute when the package runs. You can organize tasks in sequences and in loops.
  • Event handlers, which are workflows that runs in response to the events raised by a package, task, or container.
Step 1: Open SQL Server Business Intelligence Development Studio.
Step 2: Create a New Project
Step 3: Select Integration Services Project under Business Intelligence Projects and provide a name for the project.
Step 4: Add a new Data Source. Right Click on Data Sources and select New Data Source.
Step 5: Use the Data Source Wizard to add a new data source. Select ‘Create a data source based on an existing or new connection’ and click on ‘New’.
Step 6: Add the Server and Authentication information and click on Test Connection to test the connection. Then click OK.
Step 7: A default SSIS package is created under the solution called Package.dtsx. Rename this package with a meaningful name.
Step 8: Drag and drop Control Flow Items from the Toolbox on the left to the Control Flow diagram and create the package.(we will come to know about the Control flow items in next Discussion)
Step 9: Double Click on the Data Flow Task to edit each Data Flow and add data transformations. (we will come to know in the next posts)
Step 10: Save and Build the package.
Step 11: Run the package. On successful completion, the tasks will turn green.

These r the steps to create a package in ssis using BIDS environment.
we will see in the next post that how to create packages using transformations
in Data flow environment

No comments:

Post a Comment