Link to home
Start Free TrialLog in
Avatar of barnesco
barnesco

asked on

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
Avatar of arnold
arnold
Flag of United States of America image
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
Avatar of barnesco
barnesco

ASKER

I want to initiate SSIS. I can't do what your link demonstrates unless I can start the program itself.
Avatar of arnold
arnold
Flag of United States of America image
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?
Avatar of arnold
arnold
Flag of United States of America image
You would need to download the requisite components from https://msdn.microsoft.com/en-us/library/mt204009.aspx
Ssdt.
Avatar of barnesco
barnesco

ASKER

Arnold, that's what I downloaded and installed. I still can't initiate SQL Data Tools.
Avatar of arnold
arnold
Flag of United States of America image
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?
Avatar of barnesco
barnesco

ASKER

Yes, I can connect to SQL SSIS through SSMS, but that doesn't do much for me. Where are "components" in VS?
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of barnesco
barnesco

ASKER

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.
Avatar of barnesco
barnesco

ASKER

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.