• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4663
  • Last Modified:

SSIS 2014 with Visual Studio Express

I recently installed SQL Server 2014 Developer. It was installed after I installed Visual Studio Express 2013 for Windows Desktop.

I found the instructions listed below on how to create a new Integration Services project. The problem is that I cannot find the SQL Server Data Tools.

Site: http://msdn.microsoft.com/en-us/library/ms170057.aspx

Instructions:
1. On the Start menu, point to All Programs, point to Microsoft SQL Server, and click SQL Server SQL Server Data Tools.
2. On the File menu, point to New, and click Project to create a new Integration Services project.

Question:
Is it possible to create a new Integration Services project using Visual Studio Express 2013 for Windows Desktop?
0
Mark01
Asked:
Mark01
  • 8
  • 4
1 Solution
 
Randy Knight, MCMCommented:
For an unknown reason, in SQL 2014 Microsoft decided to remove SSDT from the
 normal installation and make it a separate download.

http://msdn.microsoft.com/en-us/data/hh297027
0
 
Mark01Author Commented:
I followed that link to download and install Visual Studio Express 2013 for Windows Desktop. The problem I am having is that if SSDT is installed, I do not know how to run it.
0
 
Randy Knight, MCMCommented:
When you go to create a new project, there should be a section of projects that say Business Intelligence.  Expand those and you'll see the different type (SSIS, SSAS, SSRS).
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
Mark01Author Commented:
There is no section of projects that say Business Intelligence.
0
 
Mark01Author Commented:
Here are some screenshots.
C#VB
0
 
Randy Knight, MCMCommented:
It looks to me like you didn't get the SQL Server tooling installed.  Here is what you should see.

New Projects in Visual Studio 2013 with SSDT installed
What exact download did you install?  Here is the direct link to the one you need.

http://www.microsoft.com/en-us/download/details.aspx?id=42313
0
 
Mark01Author Commented:
I don't remember the exact download I installed. All I remember is that I downloaded and installed Visual Studio Express 2013 for Windows Desktop.

I down and attempted to install Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 (from your link) today and it failed. The errors are shown below.
ErrorMore error detail.Error1c.pdf
0
 
Randy Knight, MCMCommented:
Looks like you downloaded the wrong version depending on if your computer is 32-bit or 64-bit. If you're on a 64-bit operating system you need x64.  If 32-bit you need x86.
0
 
Mark01Author Commented:
In your download link, it states that it is for both 32-bit and 64-bit. I am running a 64-bit operating system.
0
 
Mark01Author Commented:
According to your link (40295063), Visual Studio Express 2013 for Windows Desktop includes SQL Server tooling.
0
 
Mark01Author Commented:
ID: 40297521 is the correct link to download SSDT. SSDTBI_x86_ENU.exe does support both the 32-bit and 64-bit  versions. I am running an x64-based SQL instance so here are the correct instructions:
The important thing is, if you’re running an x64-based SQL instance (64-bit), make sure to select “New Instance” on the Installation Type page, and NOT “Add features to an existing instance”. Not doing so will cause it to error out.

Here is the link:
http://stackoverflow.com/questions/24989187/64-bit-microsoft-sql-server-data-tools
0
 
Mark01Author Commented:
Thank you, Randy.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now