June 2, 2015 at 1:44 pm
I have installed SQL 2014 enterprise edition in Windows server 2012 . After that I installed SSDT tool SQL 2014 CTP2 version . However I am getting below error if I try to open any package or if I try to create one . Please let me know if you faced similar issue or have solution for the same .
To design Integration Services packages in SQL Server Data Tools (SSDT). SSDT has to be installed by one of these editions of %SQL_PRODUCT_SHORT_NAME%: Standard. Enterprise. Developer, or Evaluation. To install SSDT, run SQL Server Setup and select SQL Server Data Tools.
June 3, 2015 at 8:44 am
I'm guessing, but you appear to have mixed the install of SSDT from a CTP release with an RTM install of SQL Server. Generally, that's not a good idea. If there's a way to install SSDT from the Enterprise version installation media, I'd try to de-install SSDT and re-install it using the Enterprise versions' installation media.
Steve (aka sgmunson)
Rent Servers for Income (picks and shovels strategy)
June 3, 2015 at 10:02 am
This is the version of SQL I have installed
Microsoft SQL Server 2014 - 12.0.4100.1 (X64)
Apr 20 2015 17:29:27
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
Which version of Data tool I should install . This seems tricky after new SP1 released . Any insight will be really appreciated .
June 3, 2015 at 3:18 pm
As far as I know SSDT-BI (you do want the version with SSIS templates, yes?) is managed somewhat separately from mainstream SQL Server now. It is probably best to do a search for SSDT-BI on the Microsoft download site and get it from there.
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy