Installing SSIS with SQL Server 2000

Hi All,

I have installed SSIS on server running SQL 2000 but I don't see the Business Intelligence or SSIS. I could see the SSIS service is running but do not see VS or BI version of VS.

Any ideas? Thanks in advance.

Perhaps you need to run installer of VS.NET and add BI Dev Studio.|||

Fahad,

I didn't see the option to install BI Dev Studio from VS 2005 installation. Do I need to install full VS to get the BI Dev Studio?

Please advice.

Thanks.

|||I have not done this myself as it's another group here, but my understanding is that when you install the SQL Server 2005 client tools, you'll get BIDS.|||

That was my understanding too but after installing SQL 2005 client tools and Integration Services, I don't see the BIDS.

|||

Bader Cheema wrote:

That was my understanding too but after installing SQL 2005 client tools and Integration Services, I don't see the BIDS.

Under Start->Programs->Microsoft SQL Server 2005 you don't see SQL Server Business Intelligence Development Studio?|||

I do able to see client tools but NOT BIDS.

|||I have had a similar problem installing the tools. I have installed the evaluation version of SQL 2005 including all the tools etc on a development server. BIDS is on there and works fine.

However, when I can to install the client tools on my desktop, I get management studio and all the other tools but not BIDS, the only thing that I can think of is because I use Visual Web Developer Express rather than Visual Studio.

Is there a workaround for this as its a little bit restrictive of Microsoft if this is the case.

<tuffty/>