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?
Mark01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Randy Knight, MCMPrincipal ConsultantCommented:
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, MCMPrincipal ConsultantCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mark01Author Commented:
There is no section of projects that say Business Intelligence.
0
Mark01Author Commented:
Here are some screenshots.
C#VB
0
Randy Knight, MCMPrincipal ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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, MCMPrincipal ConsultantCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.