4

I'm trying to create a new Integration Services project. By default the project targets SQL Server 2017. I need it to be SQL Server 2012, but the option is not showing up. I have existing projects which have been set to 2012 a while back, but now I can't do it anymore.

enter image description here

Any clue on why the SQL Server 2012 option isn't showing up? Is it a compatibility issue?

I'm using Visual Studio Community 2017 v15.9.7 with SSDT v15.1.61901.24070.

Dale K
  • 25,246
  • 15
  • 42
  • 71
sanfalero
  • 372
  • 2
  • 18
  • 1
    Latest version of SSDT is 15.9, maybe updating will resolve? SQL Server 2012 support was temporarily removed in 15.8 but should be in 15.1 – TomNash Feb 22 '19 at 20:32
  • Thanks @TomNash, I thought I had the latest version for some reason. I'll give it a try. – sanfalero Feb 22 '19 at 20:35
  • I was mistaken, you may have the most up to date. Check the build number in `Add/Remove Programs`, should be 14.0.16186.0 – TomNash Feb 22 '19 at 20:38
  • I had 14.0.16182.0, which is version 15.8.2. It's odd, when I go to Help > About in Visual Studio it shows 15.1.61901.24070. I'm updating now. – sanfalero Feb 22 '19 at 20:46

2 Answers2

4

That is the version of Visual Studio that you are using. To get the correct version of SSDT, you need to go into About or into Add/Remove Programs and get it for SSDT.

Anyways, the problem is that Microsoft removed Targeting to SQL Server 2012 in SSDT version 15.8.1 and subsequently re-added it in SSDT version 15.9.0 (i.e., the latest as of this posting).

Just upgrade SSDT and you will have it.

Note: Uninstall SSRS and SSAS if they are installed otherwise the SSDT upgrade will fail and you will have lots of heartburn getting it installed again.

change log is for SQL Server Data Tools (SSDT)

J Weezy
  • 3,507
  • 3
  • 32
  • 88
2

Latest version of SSDT is 15.9, maybe updating will resolve? SQL Server 2012 support was temporarily removed in 15.8 though.

TomNash
  • 3,147
  • 2
  • 21
  • 57