BIDS for SQL Server Management Studio

Question

I want to use BIDS and SSI.  Can someone assist me with this?  I have Sql Server Management Studio 2008 and Visual Studio 2008 -- both installed via web download.

Answer 1

Hi Michael,

Thank you for posting in MSDN forum.

Since this issue is related to the SQL, so we will move this issue to the SQL forum:

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=sqlintegrationservices , you will get better support.

Best Regards,

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

If you've visual studio installed check it includes BI templates included. If yes then you can develop SSIS packages using it.

Otherwise you need to get BI templates included 

see

https://sqljoe.wordpress.com/2013/08/14/configuring-bids-2008-2008-r2-and-visual-studio-2008-to-work-with-database-business-intelligence-projects-and-team-foundation-server-tfs/

Another much better option is to do full installation of sqlserver developer edition which will include BIDS which is Visual Studio itself with BI templates.

Using BI templates you can create SSIS packages, SSRS reports etc

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page

Answer 3

I want to use BIDS and SSI.  Can someone assist me with this?  I have Sql Server Management Studio 2008 and Visual Studio 2008 -- both installed via web download.

While installing SQL Server, BIDS feature should be checked and then you can find BIDS from START menu.

---

Cheers,
Vaibhav Chaudhari
[MCTS], [MCP]

Answer 4

Hi Michael,

To create a package in Business Intelligence Development Studio:

1. In Business Intelligence Development Studio, open the Integration Services project in which you want to create a package.
   
2. In Solution Explorer, right-click the SSIS Packages folder, and then click New SSIS Package.
   
3. Optionally, add control flow, data flow tasks, and event handlers to the package.
   
4. On the File menu, click Save Selected Items to save the new package.
   

For more details, please refer to the following documents:
https://msdn.microsoft.com/en-us/library/ms169917(v=sql.100).aspx
https://technet.microsoft.com/en-us/library/ms141711(v=sql.100).aspx
http://www.codeproject.com/Articles/173918/How-to-Create-your-First-SQL-Server-Integration-Se

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support

Answer 5

Hello Michael,

For which SQL Server Version do you want to develop for? If it's SQL Server 2012 or 2014 then you can use the new tools SSDT-BI = SQL Server Data Tools BI, see https://msdn.microsoft.com/en-us/data/tools.aspx , there is a link to a free download.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]