question

vishuaaryan avatar image
vishuaaryan asked

how to start BI with visual studio 2010?

I be new for BI and I want to start work BI using visual studio 2010. How I can configure the BI with VS2010 and sql server 2008r2. Please suggest me to start with BI. Thanks
sql-server-2008-r2bidsvisual-studio-2010
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

kaddie001 avatar image
kaddie001 answered
You have to install SQL Server Data Tools (SSDT). In 2010 and above, MS changed the name of the BI Tool from BIDS to SSDT. SSDT is included with the SQL Server install CD. It's a special tool that runs using the VS 2010 shell. Once that tool is installed, open it. When you open it for the first time it will look like a standard Visual Studio project and it will ask you what configuration you want to use. Select the "Business Intelligence" option. That option will install the dlls for SSIS, and SSAS.
5 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

can you tell me from where I can download this and install in my system? also tell its free or licensed?
0 Likes 0 ·
The big thing left off on this answer: You WILL NOT be able to deploy the package designed in VS 2010 to an SQL Server 2008 R2 instance. You can only work with BI packages in the same version as the SQL Server instance you are deploying to. There is no backward compatibility.
0 Likes 0 ·
Hi Shawn, Thanks for the feedback but that's not entirely true. Yes, VS 2010 and 2012 do use different versions of certain ddl files than the 2008 database does. Those versions are stored in the \\Microsoft SQL Server\\Tools\Bin. So 2008 uses Bin 100, whilst 2012 uses Bin 110. However that doesn't preclude database 2008 from being able to run packages built on 2010 or higher because all MS 2005 and higher databases can read more than one version of the ddl. You simply need to install the \Tools\Bin for the higher version of the database on the physical server, and modify the database config file to look for the higher version \Tools\Bin first, followed by the other Bins. This will give your 2008 database the ability to run both 2008 and 2010 developed packages without any issues. I have several clients that are not ready to upgrade their DBs from 2008 to 2012, however they want to use some of the features available in BIDS/SSDT 2010 and higher. And we run the 2010/2012 packages on the 2008 database without any issues every night.
0 Likes 0 ·
Just noticed I did not clarify my comment a bit. I am referring to SSIS and SSRS development with SQL Server 2012 BI tools. Those are not runnable on a lesser version of SSIS and SSRS.
0 Likes 0 ·
kaddie001 avatar image
kaddie001 answered
You can download SQL Server Express Edition which should include SSDT as an option for free from Microsoft http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
You can download SQL Server Data Tools directly from Microsoft here: [ http://msdn.microsoft.com/en-us/data/tools.aspx][1]. But anyway, if you want to start developing BI solutions for SQL Server 2008R2, you should install BIDS (Business Intelligence Development Studio) based on the VS 2008, which is part of the SQL Server Installation file. Especially if you would like develop SSIS Packages. [1]: http://msdn.microsoft.com/en-us/data/tools.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.