[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • Last Modified:

unable to find shortcut for SQL Business Intelligence Development

I'm having problems launching my SQL Server Business Intelligence Development.  I installed the sql server 2005, but when I goto the look for the shortcut in Microsoft SQL Server 2005, I cannot find it.  I know I have DTS because I see the C:\Program Files\Microsoft SQL Server\90\DTS\Binn directory.  Whats going on here????

thanks
Nick
0
countyprob
Asked:
countyprob
  • 10
  • 6
1 Solution
 
Eugene ZCommented:
"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"
0
 
countyprobAuthor Commented:
tired that but it brings up my visual studio 2005, not the integrated services development enviroment.  For instance, when I create a new project, I have visual studio 2005 vb.net and c# instead of Integrated services project.   Any other recommendations?

thanks
Nick
0
 
Eugene ZCommented:
it is VS 2005 ->IS project

can you see like in the http://aspalliance.com/947_Building_a_SQL_Server_2005_Integration_Services_Package_Using_Visual_Studio_2005?

--check
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1851893&SiteID=1
more:
http://msdn2.microsoft.com/en-us/library/ms137812.aspx

also check for ssis packs:

try
if you installed
SQL Server Management Studio
from
SQL Server Business Intelligence Development Studio
"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

---
SQL Server Management Studio->file-> connect object explorer->from pop-up login form select "integration servces" from combobox services...

---
also you can see ssis pack by using
dtexecui.exe util
--during creation sqlagent job if in step properties select type ssis pack

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
countyprobAuthor Commented:
still the problem is I can't find execution short cut

thanks
Nick
0
 
Eugene ZCommented:
did you install IS service on the box?

check windows service if you can find :
SQL Server Integration Services
if not you need install IS
0
 
countyprobAuthor Commented:
Yes, I do have IIS installed.  

thanks
Nick
0
 
Eugene ZCommented:
not IIS: I asked about
SQL Server Integration Services--- SSIS

go start-> run -> %SystemRoot%\system32\services.msc /s

and check service named
SQL Server Integration Services
0
 
countyprobAuthor Commented:
Oops.  Yes, I did find it in the windows services and it is in started status with startup type set to automatic.

thanks
Nick
0
 
Eugene ZCommented:
good:

now search your comp for the file  "devenv.exe"
0
 
countyprobAuthor Commented:
It is located in the "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE" directory.  When I double click it, the visual studio 2005 opens up.  I do file / new project and this is what I see:

http://i18.tinypic.com/4zco22g.jpg

I don't see SSIS project.

thanks
Nick
0
 
Eugene ZCommented:
I see nothing @ http://i18.tinypic.com/4zco22g.jpg

see on the top - left corner "Business Intelligence projects'

see figure 1-
http://www.devx.com/dotnet/Article/35070/1954?pf=true
0
 
countyprobAuthor Commented:
Yeh, that is what I don't see either.  The Business Intelligence project is not there.  That the problem I'm having.   It seems like they are only visual studio 2005 nodes, no SSIS.  

thanks
Nick
0
 
Eugene ZCommented:
did you install sql server 2005 server pack 1 or 2?
0
 
Eugene ZCommented:
try to create maintenences plan -save it - then try to modify -> it will open the SQL Business Intelligence Development
0
 
Eugene ZCommented:
if it does not work -> try reinstall SQL Server Integration Services
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 10
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now