Friday, 26 September 2014

Creating an SSIS Project in BIDS

Creating an SSIS Project
          Although the Import and Export Wizard is useful for generating a quick package that moves data from one source to one destination, these packages are frequently use one time of solution only at the time of starting point. But presently we will need to either develop a package that has more complicated requirements or create a set of coordinated packages. That reason you first need to create a new SSIS Project in BIDS.

            To import data from Excel and stored into Sql server by using BIDS Development tool, we have to do the following steps to create new SSIS package.

Steps:
1. Start --> Programs --> Microsoft SQL Server 2008 R2--> SQL Server Business Intelligence Development Studio (BIDS)

2. In BIDS, choose New, Project from the file Menu. (If you have Visual Studio 2008 installed separately from BIDS, you can simply select New Project from File Menu)

3. Fill out the New Project dialog box as follows:
• Under Project Types, select Business Intelligence Projects.
• Under Templates, select Integration Services Project.
• Assign a name to your Project in the Name box.
• In the Location box, either leave the default folder location for storing new Projects (Default is \Documents\Visual Studio 2008\Projects\folder) or change to location of your choice.

4. When you have finished, Click OK to build the Project. The project contains several SSIS Objects as shown below Diagram.

5. In this above Diagram shows a new project, with the default Package.dtsx package (created with the project) in the SSIS Designer. In Solution Explorer, right click of that package and then click Rename.

6. At the time of rename of package, BIDS might prompt you to rename the package object. If a message box appears that prompts you to rename the package object is well, click Yes.

7. Click the Save button on the toolbar, and then close the package by clicking the Close button in the upper right corner of the SSIS Designer.

8. Finally you are now ready to Configure and Develop your Package.

No comments:

Post a Comment