1. Open Bids
Go to Start // Programs // Microsoft SQL Server 2008 R2 and open SQL Server Business Intelligence Development Studio
Below is example using Windows 7 and SQL Server 2008 R2.
1. Create new project
In BIDS select File // New // Project…
You will get new project dialog box where you should:
- Select Business Intelligence Projects in Project Types
- Select Integration Services Project in Templates:
- Give it a name (Try to avoid spaces for compatibility reasons)
- Remember or change location
- Click ok to create SSIS Project
