How to add a new Integration Services project to a solution in MS SQL Server?

Follow the steps given below:

1.In Business Intelligence Development Studio, open the solution to which you want to add a new Integration Services project, and do one of the following:
a.Right-click the solution, click Add, and then click New Project.
b.On the File menu, point to Add, and then click New Project.
2.In the Add New Project dialog box, click Integration Services Project in the Templates pane.
3.Optionally, edit the project name and location.
4.Click OK.

Tags: Microsoft, Database, Cube, ETL, ROLAP

Related