SSIS Designer

I have an MSDN subscription so I can download pretty much whatever combination of SQL Server and Visual Studio I need. My immediate goal is to learn and create SSIS packages. I started with SQL Server/VS 2208 R2, but then I learned that there are some SSIS components that are not available in 2008 that I would like to use. I also had a problem with the script component. So I uninstalled 2008, and installed the combination of SQL Server 2014 and VS 2015 (several times!), but I could never get the SSIS designer/templates to show up in VS 2015. I understand that Microsoft has changed the way the two interact using SQL Server Data Tools or somesuch, and that I had to install VS 2013, which I proceeded to do, but that still doesn't work. So I am now in the process of uninstalling all that (I'm getting pretty good at that!).

So my question is, can someone please suggest a combination of SQL Server and Visual Studio that I can install on a stand-alone PC that will allow me to create - and contains the templates for - SSIS packages in Visual Studio ? I don't care what versions they are, as long as they are more recent than 2008. The only other thing I'll be using Visual Studio for is C# programming (so I need actual Visual Studio - not just a shell).

Thank you.
bassman592Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Brian CroweDatabase AdministratorCommented:
The SSIS Data Tools are now separate and from what I understand they are no longer even an option on the SQL Server 2014 install.  Here is the link where you can download them.

http://www.microsoft.com/en-us/download/details.aspx?id=42313
bassman592Author Commented:
I tried that - no luck.
Brian CroweDatabase AdministratorCommented:
My guess is that you have inadvertently created a mess for yourself with multiple install/uninstalls while trying to get something to work.  I can tell you that I have recently set up more than one machine using SQL Server 2014, Visual Studio 2013 and the Data Tools from the link I provided earlier.

My suggestion is to start from a clean machine if possible (are you working with virtuals) or make sure you uninstall everything but the SQL Server instance and try reinstalling Visual Studio and the Data Tools.

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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

bassman592Author Commented:
Thank you for the suggestion  - I will try exactly that and let you know how it turns out!
Dung DinhDBA and Business Intelligence DeveloperCommented:
Could you provide more detail which your problem? I'm sure that we can install multiple versions SQL Server / Visual Studio/ Data Tools in stand-alone PC. My PC was installed SQL Server 2008R2 Dev, SQL Server 2014 Dev, Visual Studio 2010 and Data Tool for Visual Studio 2013 and they're working.

Thanks,
bassman592Author Commented:
Thank you Dung. I'm going to first try Brian's suggestion and then go from there. I agree with him that I probably need to clear everything out and start from scratch. I will post my results, but it will take a few days.
bassman592Author Commented:
Thanks Brian! I actually cleaned everything out and started from scratch. But it works great now. SQL Server 2014 + Visual Studio 2013 + Data Tools. Now I can do SSIS and C# and I'm happy as a clam!
Brian CroweDatabase AdministratorCommented:
I'm glad it worked
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.