Solved

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

Posted on 2006-11-23
4
974 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
  • 2
  • 2
4 Comments
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
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
Comment Utility
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 42

Accepted Solution

by:
EugeneZ earned 250 total points
Comment Utility
<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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now