Adding SSDT BI Templates in Visual Studio

Question

Post reply

Adding SSDT BI Templates in Visual Studio

loki70

SSC-Addicted

Points: 464
More actions
December 17, 2015 at 5:24 am

#307115

I have a new laptop with Visual Studio 2015 Enterprise and SQL Server 2016 CTP 3.1 installed on it. I want to develop SSIS & SSRS projects using this setup, but I am having a hard time getting the Business Intelligence templates to show up in VS.
I installed the SQL Server Data Tools for Visual Studio 2015 from here:
https://msdn.microsoft.com/en-us/mt186501.aspx
This installation seemed to work, but the BI templates still did not appear in VS.
After this was installed, I started up the SQL 2016 installation again to see if I could add this as a feature in the installation. It was not an option in the Feature Selection area. I tried both the "Perform new installation of SQL" and "Add feature to an existing instance" options during the setup wizard.
What am I missing here? In doing some research, it seems like these BI templates should be available for VS 2015. I would greatly appreciate any suggestions. Thank you!

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Brad Feaker-195979 SSChasing Mays Points: 639 More actions · Answer 1

You need to use this install instead...

https://msdn.microsoft.com/en-us/mt429383

It is the 2016 Preview...it works fine for me.

Regards

Brad Feaker"Tantum religio potuit suadere malorum." - Lucretius

loki70 SSC-Addicted Points: 464 More actions · Answer 2

Grasshopper - That worked perfectly! I never stumbled on this "preview" version in my searches, but your link worked great.

Thank you very much for your quick reply!

Phil Parkin SSC Guru Points: 246959 More actions · Answer 3

loki70 (12/17/2015)
Grasshopper - That worked perfectly! I never stumbled on this "preview" version in my searches, but your link worked great.
Thank you very much for your quick reply!

You could also refer to him as 'Brad' 🙂

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

Phil Parkin (12/17/2015)
loki70 (12/17/2015)
Grasshopper - That worked perfectly! I never stumbled on this "preview" version in my searches, but your link worked great.
Thank you very much for your quick reply!
You could also refer to him as 'Brad' 🙂

Some might refer to Phil as Certifiable, but I'll stay away from that one. 😀

Just kidding Phil 🙂

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Phil Parkin SSC Guru Points: 246959 More actions · Answer 5

Alvin Ramard (12/17/2015)
Phil Parkin (12/17/2015)
loki70 (12/17/2015)
Grasshopper - That worked perfectly! I never stumbled on this "preview" version in my searches, but your link worked great.
Thank you very much for your quick reply!
You could also refer to him as 'Brad' 🙂
Some might refer to Phil as Certifiable, but I'll stay away from that one. 😀
Just kidding Phil 🙂

Hehe, you're not wrong! 😀

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 6

Phil Parkin (12/17/2015)
Alvin Ramard (12/17/2015)
Phil Parkin (12/17/2015)
loki70 (12/17/2015)
Grasshopper - That worked perfectly! I never stumbled on this "preview" version in my searches, but your link worked great.
Thank you very much for your quick reply!
You could also refer to him as 'Brad' 🙂
Some might refer to Phil as Certifiable, but I'll stay away from that one. 😀
Just kidding Phil 🙂
Hehe, you're not wrong! 😀

Welcome to the group then. 😛

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Brad Feaker-195979 SSChasing Mays Points: 639 More actions · Answer 7

No problem...

Brad Feaker"Tantum religio potuit suadere malorum." - Lucretius

Brad Feaker-195979 SSChasing Mays Points: 639 More actions · Answer 8

Memphis PASS Chapter? I'll be seeing you guys soon. Been working in Nashville until this June and have been meaning to attend...but I will be around in January if you guys have a meeting scheduled.

'Grasshopper'...aka 'Brad'

Brad Feaker"Tantum religio potuit suadere malorum." - Lucretius

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 9

Brad Feaker-195979 (12/17/2015)
Memphis PASS Chapter? I'll be seeing you guys soon. Been working in Nashville until this June and have been meaning to attend...but I will be around in January if you guys have a meeting scheduled.
'Grasshopper'...aka 'Brad'

We're having a meeting on Jan 14th where we'll be going over some of the new stuff in SQL 2016. I've have the details up on our site soon.

We'd be happy to have you join us.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

kbenbow1277 Newbie Points: 7 More actions · Answer 10

Brad Feaker-195979 - Thursday, December 17, 2015 6:08 AM
You need to use this install instead...https://msdn.microsoft.com/en-us/mt429383It is the 2016 Preview...it works fine for me.Regards

Hello,

I am not getting much help from my IT department. Thought I'd jump on this old thread. I have SQL Server Mgt Studio and Visual Studio 2015. Now, trying to get the BI templates to show up on Visual Studio. I followed the instructions to download the pack from here: https://msdn.microsoft.com/en-us/mt429383 per your suggestion. I got this message below. When I try to search for this in Microsoft, it is very fuzzy on what to download. That particular title is not available. Where do I get the CLR type and what is it for?

Se

ryanbesko Ten Centuries Points: 1364 More actions · Answer 11

kbenbow1277 - Wednesday, January 17, 2018 1:47 PM
Brad Feaker-195979 - Thursday, December 17, 2015 6:08 AM
You need to use this install instead...https://msdn.microsoft.com/en-us/mt429383It is the 2016 Preview...it works fine for me.Regards
Hello,
I am not getting much help from my IT department. Thought I'd jump on this old thread. I have SQL Server Mgt Studio and Visual Studio 2015. Now, trying to get the BI templates to show up on Visual Studio. I followed the instructions to download the pack from here: https://msdn.microsoft.com/en-us/mt429383 per your suggestion. I got this message below. When I try to search for this in Microsoft, it is very fuzzy on what to download. That particular title is not available. Where do I get the CLR type and what is it for?
Se

If you are downloading from the link it's a preview, i.e. not the final product. Try with the correct link and maybe your luck will change.
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

Brad Feaker-195979 SSChasing Mays Points: 639 More actions · Answer 12

Take a look here...

https://social.msdn.microsoft.com/Forums/security/en-US/edb5c2a4-ea69-4440-b2a2-0d1f156b8263/clr-types-for-sql-server-2016-install-error?forum=SQLServer2016Preview

And may I ask why you are using RC3 instead of RTM?

Brad Feaker"Tantum religio potuit suadere malorum." - Lucretius