SSIS data tool issue in SQL 2014
-
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.
-
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) -
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 .
-
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