Solved

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

Posted on 2006-11-23
4
986 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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

717 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