BUSINESS INTEELLIGENCE DEVELOPMENT STUDIO

• Click on start button and then click on “All Programs”

• Click on the “Microsoft SQL Server 2008 R2”, find the below screen shot for reference.

• Under the “Microsoft SQL Server 2008 R2”, select “SQL Server Business Intelligence Development Studo”.

• Then BIDS (Business Intelligence Development Studio) will open. Click on the “Create project option” to create new project.

• New project window will open.

• Choose the template as “Integration Services Project”. Give the required “Integration Services Project” name and “location” to store the project.

• Click “OK” button, then “Sample project-Microsoft Visual Studio” window will open.

•  we can start the SSIS package creation under the solution.