SSIS - SQL Server Integration Service is not showing up in BI Development Studio

Hi,

I.m using MS-SQL 2005 Developer edition with full installation, including "SSIS - SQL Server Integration Services". I also have Visual Studio 2005 Professional Edition.'

When I use the Business Intelligence Development Studio, and try to create a new project (Business Intelligence Projects),  I can't see the "Integration Services Project" template, I only see "Report Server Project and Report Server Project Wizard" templates.

I don't know if it's missing some other step to include de SSIS.

Thank you.


robertomelo13Asked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
<I first installed the VS 2005 and mys Sql server 2005 is SP1.>
Hmm it could be it - I did sql server 2005  and it installed VS2005

-----
ok:
check what you have
at
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems



review:
How to create a package template in SQL Server Business Intelligence Development Studio
http://support.microsoft.com/kb/908018

---


--
Introducing Business Intelligence Development Studio  


http://msdn2.microsoft.com/en-gb/library/ms173767.aspx
0
 
Eugene ZCommented:
check the doc:
SQL Server' 2005: Integration Services (PDF)
download.microsoft.com/documents/australia/teched2005/hol/HOL073.pdf
---
did you install the VS 2005 after you installed the sql server 2005 with BI?
BTW:
did you install sql servers 2005 SP1
0
 
robertomelo13Author Commented:
Hi EugeneZ,

This document is very interesting, but it explains how to create a project and it assumes that all templates (Analysis Service Proj, Import Analysis Services, Integration Services Project ) are available.

In my case, I can't see them with BI.

I first installed the VS 2005 and mys Sql server 2005 is SP1.

Thanks.
0
 
robertomelo13Author Commented:
You are right my friend !

I uninstalled both VS 2005 and SQL 2005, I restore my XP to System checkpoint before the VS 2005 and SQL 2005  installations and started installing  SQL 2005.

Now it works.

Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.