Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2006-11-23
4
Medium Priority
?
1,000 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 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 1000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

580 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