SQL 2005: BIDS/VS2005
  Home FAQ Contact Sign in
microsoft.public.sqlserver.setup only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... sqlserver.setup Profile…
 Up
SQL 2005: BIDS/VS2005         


Date: Jan 31, 2008 14:16

Hello all,

I'm assuming BIDS and VS2005 are the same thing.

I don't remember if VS2005 was already on this computer before installing
SQL 2005 Client Tools, but in Start button > All Programs, BIDS shows up in
"MS SQL Server 2005" program folder and VS2005 has its own program folder.
It looks like it is the exact same thing whether I open it via BIDS or via
VS2005. Does the install process install it in both locations? Maybe it
was on here already, I just never noticed it because I never had a need for
it.

I was going to look into creating a custom control flow task for SSIS, so I
looked it up in BOL. I found the ?tutorial? (i guess you could call it)
"Creating a Custom Increment Task Sample" that I was going to work through.
When I tried to open the provided VB solution (didn't try C+/C#...which ever
one it is...don't know that language) in VS2005 (not sure if it is VS2005 or
BIDS), I get the following error:

The application for project '[file path]\IncrementTask.vbproj' is not
installed. Make sure the application for the project type (.vbproj) is
installed.
Show full article (1.53Kb)
10 Comments
Re: SQL 2005: BIDS/VS2005         


Author: Ekrem Önsoy
Date: Jan 31, 2008 15:29

Hi Conan,

BIDS is not exactly VS2005 as you assume.

Actually yes, BIDS is VS2005, that's correct. However you can not build
softwares in "VB.Net, ASP.Net, CS.Net" etc. VS2005 is installed with SQL
Server 2005 only for creating Reports, Analysis Services Projects,
Integration Services Projects, Report Model Projects etc. for SQL Server
2005.

Installing BIDS is an optional choice and you make it when you were
installing SQL Server 2005. Also, it does not ship with SQL Server 2005
Express Edition.

--
Ekrem Önsoy

"Conan Kelly" msnNOSPAM.comNOSPAM> wrote in message
news:mNroj.183538$MJ6.142085@bgtnsc05-news.ops.worldnet.att.net...
> Hello all,
>
> I'm assuming BIDS and VS2005 are the same thing...
Show full article (2.27Kb)
no comments
Re: SQL 2005: BIDS/VS2005         


Date: Jan 31, 2008 16:14

Ekrem,

Thanks for the feedback.

I think we have the standard editon of SQL Server.

So, I'm assuming that VS2005 was on my computer prior to installng SQL
Server Client Tools, since VS2005 has it's own program folder in my start
menu. Like I mentioned before, I can't tell the difference between BIDS and
VS2005, and I get the same error messages when I try to open the sample
project/solution with either.
> Actually yes, BIDS is VS2005, that's correct. However you can not build
> softwares in "VB.Net, ASP.Net, CS.Net" etc.

I'm assuming that I should be able to open the sample project/solution with
VS2005, but not BIDS. <--Is that correct?

How can I tell what languages are installed/can be used with VS2005 for
developing?

Has anyone else had these error messages when trying to open these sample
projects solutions? What steps where taken to resolve the issue?

Thanks again for all of your help,

Conan

"Ekrem
no comments
Re: SQL 2005: BIDS/VS2005         


Author: Ekrem Önsoy
Date: Feb 1, 2008 01:12

Conan,

Open BIDS or Visual Studio 2005 (If you installed it before). You can tell
the difference easily when you go to "File \ New -> Project". If you see
only "Business Intelligence Projects" in the "Project types" tree then you
had not installed Visual Studio 2005 before BIDS.

If you had, then you'd have Visual Basic, Visual C# etc (according to your
choices when you installed VS2005) in that list as well.

--
Ekrem Önsoy

"Conan Kelly" msnNOSPAM.comNOSPAM> wrote in message
news:kvtoj.525290$kj1.108667@bgtnsc04-news.ops.worldnet.att.net...
> Ekrem,
>
> Thanks for the feedback.
>
> I think we have the standard...
Show full article (4.10Kb)
no comments
Re: SQL 2005: BIDS/VS2005         


Date: Feb 1, 2008 10:28

Ekrem,

Thanks again for the feedback.

My options are:
--Business Intelligence Projects
--Other Project Types
----Visual Studio Solutions (sub of Other Project Types)

When I click VS Solutions, I only have 2 items in the template box: Blank
Solution (under VS Installed templates) and Search Online Templates...(under
My Templates)

I'm guessing then, that I can't use this VS2005 to develop anything in VB,
VC#, etc..., including the sample solutions included with SQL Server.

If that is the case, it would have been nice of them to note that in BOL (or
did they and I just missed it). Why would they include samples with SQL
Server that you can't do anything with. Shouldn't everything that I need to
work with the included samples be included on the SQL Server install disks?

Or does this have to do with the options that were chosen when client tools
(BIDS/VS2005) were installed. If I go get the SQL Server install disks, and
try to reinstall BIDS/VS with different options, will this allow me to work
with the included samples?
Show full article (1.11Kb)
no comments
Re: SQL 2005: BIDS/VS2005         


Author: Ekrem Önsoy
Date: Feb 1, 2008 13:26

It seems that you did not install Visual Studio before SQL Server 2005
installation. Because now you can only create SQL Server related projects in
your VS2005.

I don't know what samples you are talking about? Can you clarify that?

--
Ekrem Önsoy

"Conan Kelly" msnNOSPAM.comNOSPAM> wrote in message
news:TwJoj.530041$kj1.378112@bgtnsc04-news.ops.worldnet.att.net...
> Ekrem,
>
> Thanks again for the feedback.
>
> My options are...
Show full article (6.03Kb)
no comments
Re: SQL 2005: BIDS/VS2005         


Date: Feb 1, 2008 14:16

Ekrem,

I was looking into creating a Custom Control Flow Task for SSIS, so I looked
up "Custom Task" in BOL. It showed instructions and a ?tutorial? (if you
want to call it that) on how to do this: "For a working sample of a custom
task, see Creating a Custom Increment Task Sample."

In "Creating a Custom Increment Task Sample", it mentions opening a vb
project in VS, but I get the error messages (see OP).

It doesn't make sense (to me anyways) that SQL Server would include samples
that you can't work with.

Thanks again for all of your help,

Conan

"Ekrem
no comments
Re: SQL 2005: BIDS/VS2005         


Author: Ekrem Önsoy
Date: Feb 1, 2008 16:58

In that article it says the following:

===================
Prerequisites
Before you run this coding sample, make sure that the following conditions
are met:

The sample package and its associated sample data must first be installed to
the local hard disk. For more information, see the Books Online topic,
"Installing and Compiling Integration Services Coding Samples."

Microsoft Visual Studio 2005

Microsoft SQL Server 2005 Integration Services
===================

So, obviously you need VS2005 itself rather than BIDS to run this sample. VS
is also another Microsoft product, so it's quite normal to me that they
advertise their another product and encourage users to use it.

--
Ekrem Önsoy

"Conan Kelly" msnNOSPAM.comNOSPAM> wrote in message
news:LSMoj.189167$MJ6.130809@bgtnsc05-news.ops.worldnet.att.net...
> Ekrem,
>
> I was looking into creating a Custom Control Flow...
Show full article (7.97Kb)
no comments
Re: SQL 2005: BIDS/VS2005         


Date: Feb 1, 2008 17:09

Ekrem,

I saw that part, including the "MS VS 2005", but it didn't dawn on me til
just now, because I was assuming BIDS & VS was the same thing (or was
thinking that a full version of VS 2005 was installed on this machine prior
to installing SQL Server Client Tools).

Thanks for helping me out.

Conan

"Ekrem
no comments
Re: SQL 2005: BIDS/VS2005         


Author: Ekrem Önsoy
Date: Feb 2, 2008 01:12

I already told you in my previous posts, BIDS uses VS2005' s shell. However
this does not mean BIDS is VS2005. When you have only BIDS installed, you'll
not be able to create VB, C#, Web etc applications. It'll just let you to
create Reports\Analysis\SSIS stuff which are about the SQL Server 2005 only.

If you had VS 2005 installed prior SQL Server 2005 installation, then when
you go to Start\Programs\Microsoft SQL Server 2005 and click BIDS then it'd
run and you'd see your other options (like the ones I mentioned above)
besides BI stuff. They just use the same shell.

--
Ekrem Önsoy

"Conan Kelly" msnNOSPAM.comNOSPAM> wrote in message
news:EpPoj.189514$MJ6.23940@bgtnsc05-news.ops.worldnet.att.net...
> Ekrem,
>
> I saw that part, including the "MS VS 2005", but it...
Show full article (9.66Kb)
no comments
1 2