What are the Tools required for Creating SSIS package?

Question

Hi all I am planning to create the SSIS package for my project in SQL server 2012. Kindly list out what are the tools/software need to create this in SQL 2012. Please mention with the tool version. thanks Hari

Manish Kumar · Answer

Hi Hari While installation of Sql server 2014 SP1have you selected integration services if not then please run the set up again and in installation type check Add features to existing instance of Sql server 2014 and in next select Integration service. In case integration services is already installed then go to start>>All Programs>>Microsoft Sql server 2014>>Sql server Data tools (this is the tool where you can create your own SSIS package.) Thanks Manish

Vishal Prajapati · Answer

Hello Hari...please follow this links: 1) http://stackoverflow.com/questions/14696098/what-tools-do-i-need-to-create-ssis-packages-on-windows-8 2) http://stackoverflow.com/questions/10641743/what-tools-do-i-need-to-create-an-ssis-package-in-sql-server-2008-express

Manish Kumar · Answer

No visual studio is not required .

Hariharan Krishnamoorthi · Answer

Hi Manish Do we need Visual Studio for SSIS package? Which version of VS would be better for SQL 2014?

Hariharan Krishnamoorthi · Answer

Hi Manish Thanks for your comment. Now i am going to create SSIS package on SQL server 2014 - Service Pack 1. Please share the required software to proceed.

Manish Kumar · Answer

HI Hari Which version of Sql server 2012 you are using. Except express edition Integration service are shipped with all version of Sql server . Thanks Manish