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
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 QL 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
I hope you found this tutorial useful. Feel free to post questions and comments below.
Click the following link to find out how to create SSIS Package
Hope that helps
Emil
|
Share:
Comments Add Comment
Name:
Edward
Comment:
Hi,
I have installed BIDS 2005, when i go for new project, i could not find Integration service template.
can u plz help me.
Date Posted:
01/12/2011 7:55:18 AM
Name:
Emil
Comment:
Hi Edward, Which edition of SQL Server have you installed?
Date Posted:
03/12/2011 10:53:50 AM
Name:
Edward
Comment:
SQL server 2005
Date Posted:
05/12/2011 9:45:46 AM
Name:
Emil
Comment:
Edward I understand you use 2005 version but which edition? You can check edition by running this SQL.... select @@version. Feel free to use "contact" menu at the top to send me a message as currently I am not notified about new comments on my blog (still on to do list).
Date Posted:
06/12/2011 1:17:43 PM
Name:
Terrence
Comment:
Hi
My first time using BIDS. Thanks for making it so simple and straightforward. Exactly what I was looking for!
Date Posted:
25/01/2012 8:08:36 AM
Name:
Swamy
Comment:
It is damn usefull!!! KUDOS!
Date Posted:
01/02/2012 5:51:12 AM
Name:
Das
Comment:
Simple and best.
Thanks.
Date Posted:
10/03/2012 8:36:26 AM
Share your thoughts, questions and suggest improvements:
Add Comment
