Solved

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

Posted on 2006-11-23
4
984 Views
Last Modified: 2012-05-05
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.


0
Comment
Question by:robertomelo13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 18003857
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
 

Author Comment

by:robertomelo13
ID: 18004110
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
 
LVL 43

Accepted Solution

by:
Eugene Z earned 250 total points
ID: 18004447
<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
 

Author Comment

by:robertomelo13
ID: 18019401
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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question