BIDS not Present 6

[Skittle]

This is wierd.

I installed the Developer edition of SQL 2005 some months ago. Up to now I have been fiddling about with query manager but now want to start using the 2005 equivalent of SQL 2000's DTS. The help indicates I should access BIDS from START-->PROGRAMS-->SQL SERVER 2005 . . . but BIDS is not there. I have tried adding it as part of the 'Workstation Components, Books Online, and Development Tools' via setup but setup tells me it is already installed.

Am I missing something dumb here or should I just unistall and start again.

Dazed and confused

 

[ptheriault]

Skittle,
I'm not sure what BIDS is? The SQL Server 2005 version of DTS is SSIS. SQL Server Intergration Services.

- Paul
- Database performance looks fine, it must be the Network!

 

[Skittle]

It's an environment similar in appearence to visual studio
( from what I can see in the book ) that is called 'Business Intelligence Developers Studio'.

My understanding is that it gives you the ability to set up jobs in a similar way to DTS with connections, containers, tasks, 'on sucess' logic, 'on failure' logic etc. From my fumblings with SSIS so far, SSIS only alows you to edit setting by selecting the run option against a SSIS package within SSIS. It doesn't have a GUI flowchart feel to it and at first glance doesn't appear to have the same flow control.


Dazed and confused

 

[ptheriault]

Ok, We are on the same page now. When I look in my folder start -> programs -> Microsoft SQL Server 2005 I do have SQL Server Business Intelligence Development Studio. I am just getting started with SSIS myself and I guess that is the tool you use to create the packages.

Here is the target for my install.

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

Can you browse to that path? Do you have the devenv.exe on your PC?

- Paul
- Database performance looks fine, it must be the Network!

 

[Skittle]

Yes I can browse to it.

My understanding is that you use the Maintenance Wizard or the Import/Export option on a database to set up a SSIS package. This doesn't seem as powerful to me as good old DTS - at least from a design point of view - so I rumaged around and found a reference to BIDS but could not access it as described in the article.

The install looks OK so maybe the Developer version does not install it? Which version are you using? Developer is supposed to have the same capabilities as Enterprise so I still think I've more likely go an install issue .



Dazed and confused

 

[ptheriault]

I installed my tool set on my local PC off of the Enterprise disk. We only use DEV or Enterprise Editions here.

- Paul
- Database performance looks fine, it must be the Network!

 

[Skittle]

Hmmmm. Well I called the .exe and it brings up Visual Studio 2005 - which looks very different to the VB.Net environment I tinkered with a few years ago. Perhaps the reason DTS has gone is to direct us to use Visual Studio instead for anything beyond a simple import or export.

Still confused as to why I can't call from within the SQL Server program group.

Dazed and confused

 

[ptheriault]

That is correct, The new SSIS is supposed to help .net developers but at the expense of DBA's who were comfortable with DTS.
I do know that you must connect to the intergration services from within SQL Server Managment Studio to view your packages.
From object explorer, select connect -> Intergration Services.

- Paul
- Database performance looks fine, it must be the Network!

 

[Skittle]

Yuop I can do that bit.

Have you installed Visual Studio seperately?

I might have to resort to uninstalling and trying again.
I think I'll put my VB.Net on first - although it's not the new version.

Dazed and confused

 

[ptheriault]

I did't install VS seperately. Maybe re-installing would be best.

- Paul
- Database performance looks fine, it must be the Network!

 

[Skittle]

Aha!! I will try that first then.
I'll let you know how I do.

Dazed and confused

 

[SQLBill]

I don't think BIDS is a default install. I believe you need to select it from the Client Tool list when installing.
(but I could be wrong - wouldn't be the first time)

-SQLBill

Posting advice: FAQ481-4875

 

[Skittle]

I put the CD in and tried to modify the install but the client tools option was already fully selected. BIDS is part of the client tools so I assume it should be there.



Dazed and confused

 

[SQLBill]

Look in your program list...do you show Microsoft Visual Studio 2005? When I installed SQL Server 2005 Client Tools, it install that also. If you don't have that in your program list, then something failed in the install. Do you have enough space?

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

BIDS is a default install (if you install the client tools).

Start > Programs > Microsoft SQL Server 2005 > SQL Server Business Intelligence Development Studio

If you don't have the shortcut, maybe someone removed it?

If do launch the devenv.exe (and create a new shortcut). This will open the VS.NET 2005 editor (it looks different than the .NET 1.1 editor).

Goto File > New > Project. Select Integration Services for the project type, and select a location to build the new project (as this is .NET you have to create the project and folder before you can do any editing, unlike old DTS).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Skittle]

Has anybody come across an article or book that explains how BIDS fits into the SQL 2005 architecture and how to use it?

I'm only fumbling around with the MCTS books at the moment but this seems to me to be pretty important. It is after all the replacements for DTS and I feel I need to know about it regardless of wether or not the MCTS covers it.

Dazed and confused

 

[Skittle]

After a bit of searching, it looks like the best option is Microsofts training course on the subject at:-

https://www.microsoftelearning.com/eLearning/offerContent.aspx?offerPriceId=66792

$99. Yuk!
Still I'm in the UK so thats £50 which is no more than a top end technical book I guess.



Dazed and confused

 

[onpnt]

I would suggest using Microsoft's virtual labs if you are either unsure of your installation or simply need to get into something like SSIS or BIDS in general. They have labs you can go through in pdf form you can save and review without having to be in the labs.

Virrtual Labs



[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[Catadmin]

BIDs might fail to install for a number of reasons. Did you check your install log / report to see why it didn't go?

Just an FYI: If you're going to be using Visual Studio 2005 (not the BIDS version, but the regular version), this needs to be installed BEFORE you install the SQL Server 2005 client tools. If you've reversed the order, then you're going to have to un-install everything and re-install it properly or BIDS (and a few other things) won't work properly.

Worse, (the last time I checked) you can't create SSIS packages from the regular Visual Studio Install. Meaning, if you install VS 2005 only, Integration Services Projects are not available. You actually have to install SQL Server 2005 to get the ability to create Integration Services projects.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[MDXer]

THis doesn't address the original post of
where to find or how to install bids but rather an attempt to dispell some misconceptions on what it is or what it does.

BIDS is your development IDE it does not replace DTS, or Analysis services. The types of projects you build and the underlying Technologies are what replace DTS and MS AS 2K. SSIS which is the replacement of DTS was built from the ground up and has no legacy DTS code in it.

As for it helping .NET developers unless the .NET developers are well versed in ETL tools it really isn't going to be much use other than the scripting objects.

The manner in which SSIS operates makes it far better than DTS ever could be.

1) Deployed packages are binary files that can only be executed. This prevents people from opening or editing packages that have been deployed to a production enviroment.

2) If you use data flow tasks rather than a series or execute SQL tasks you actually work with and manipulate your data in memory reducing Disk IO since you are no longer inserting or updating tables. This of course inceases your memory usage but also increases your performance.

3) Because you everything you do in the data flow affects downstream objects you really need to have your process defined so you don't keep trying to add things at the start.

4)Packages are almost 100% configurable. You can have connection strings and anyother variable stored to a number of different locations. Again reducing the need for people to edit packages after they have left development.

5) Deployment all packages that are part of your Solution are deplyed through a single deployment process. No longer do you have to attach 3 dozen packages. One manifest file will deploy the entire solution.

Intense recent development and testing has shown a vast improvement in our environment. A Process that used to take 50 minutes to process 5 days of data now takes 2.5 minutes. With the manner in how data is moved through the data flow I can run the same process for 6 months in 15 minutes.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck