How to start SSIS

I've installed a SQL 2014 instance, VS Professional 2015 and SQL Data Tools for VS 2015, but I don't see a SSIS template in VS nor where to start the SQL Data Tools program (it's not in Programs > Microsoft SQL Server 2014 > SQL Data Tools or Integration Services.

How the heck do you start a new SSIS project?

Thanks
barnescoAsked:
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.

arnoldCommented:
Not sure. Understand what you are trying what you are ending up.


See if hge below write up on the process to achieve your goals.

http://blogs.msdn.com/b/meer_alam/archive/2014/08/11/ssis-data-source-connection-information-parameterization-with-environment-variable.aspx
0
barnescoAuthor Commented:
I want to initiate SSIS. I can't do what your link demonstrates unless I can start the program itself.
0
arnoldCommented:
When you initiate a connection to the SQL server, are you using the integration service as the destination?
Or are you connecting to the db engine?
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.

arnoldCommented:
You would need to download the requisite components from https://msdn.microsoft.com/en-us/library/mt204009.aspx
Ssdt.
0
barnescoAuthor Commented:
Arnold, that's what I downloaded and installed. I still can't initiate SQL Data Tools.
0
arnoldCommented:
Double check your vs 2015 installed components you may have missed the ones you need.
Using ssms, you are able to connect to the ssis of the SQL server?
0
barnescoAuthor Commented:
Yes, I can connect to SQL SSIS through SSMS, but that doesn't do much for me. Where are "components" in VS?
0
arnoldCommented:
Did you install the business inteligence components?

https://msdn.microsoft.com/en-us/library/jj856966.aspx
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
barnescoAuthor Commented:
Ok, that might be it. I just read there are two components to install SSDT and SSDT-BI, which is your link. Thing is SSDT-BI is not released for VS 2015, so I may need to go back to VS 2013.

I'll let you know in a bit.
0
barnescoAuthor Commented:
Since Microsoft removed SSDT from SQL 2014 installation, there are two tools to download and install--SSDT and SSDT-BI. VS 2013 shell is installed automatically if not already installed to develop reports, analysis and integration projects.
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.