How to create a new project in SSIS by examples

To create a new project in SSIS (Sql server integration services) we have to follow following steps:

Step 1: Fire up BIDS (Business Intelligence Development Studio)

For this go to the Start menu -> All programs -> Microsoft sql server 2008 r2 - > Sql server Business Intelligence Development Studio

And run the Sql server Business Intelligence Development Studio as an administrator

Step 2: You may get confirmation popup like: Do you want to allow the following program to make changes to this computer?

Click on Yes button.

Step 3: After this BIDS will open.  To create a new project go to the: File - > New - > Project  

Step4: From Visual Studio installed templates choose the: Integration services project

Name: We can write any name of the project.

Location: Path of the folder where we want to save the project.

Solution name: You can write any name of the solution folder of the project. If we don’t want to create folder for solution unchecked the Create directory for solution check box

Step5: Now click on OK button. We will get following screen where we can create many packages.