Nov 12, 2013

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.

No comments:

Post a Comment