In this tutorial I will show you how to create an SSIS Project using SQL Server Integration Services 2008 R2 (Instruction should be very similar in 2008 and 2005).
How to create an SSIS Project
1) Open BIDS
To get full access to this page
You should have SQL Server (2005 or higher) installed on your machine with BIDS.
Go to Start // Programs // Microsoft SQL Server (with version you have installed) and open SQL Server Business Intelligence Development Studio
Below is example using Windows 7 and SQL Server 2008 R2.
1) Create new project
Become a member or Sign in
Membership is just $3.99/month