SSIS: How to Create a SSIS Project in BIDS

The interesting thing, when you start working with SSIS, is that you don't have to start by creating a project first. You can just go to SQL Server Management Studio (SSMS) and use Import and Export Wizard from there to create a package. Normally the Import and Export Wizard is useful for generating a quick package that moves data from one source to a destination. But if you want to create a package that has more complicated requirements or if you want to create a set of coordinated packages, you need to create a new SSIS project in BIDS.

Notes:

• To Launch BIDS, from Start menu --> select Microsoft SQL Server 2008 --> and then SQL Server Business Intelligence Development Studio (BIDS).
• BIDS in SQL Server 2008 uses Microsoft Visual Studio 2008 interface with specific templates to create Business Intelligence (BI) objects.

To create a new SQL Server Integration Services (SSIS) Project follow those steps:

1. In BIDS, select File / New / Project:

     2. In the New Project dialog box:

• Under Project Types, select Business Intelligence Projects.
• Under Templates, select Integration Services Project.
• In the Name box type the name of your project.
• In the Location box, either leave the default folder location ( ..\Documents\Visual Studio 2008\Projects\ folder) or change it to a location of your choice.

     3. Click OK to build the project.

Look at the Solution Explorer in BIDS and notice that under the project that you just created you will have a few logical folders created automatically as well as a new SSIS package named Package.dtsx.

You can rename the Package.dtsx by right clicking and choosing Rename.
Now you can configure and develop your package.