I am running Windows 8 and need to develop SSIS packages.
The version of SSIS packages I need are SQL Server 2008 R2.
I am new to SSIS but it is my understanding that I need to install SQL Server 2008 R2 and Visual Studio 2010 in order to be able to create an Integration Services project (which will contain my SSIS package).Is this correct?
Does anyone know what I need to install? I have installed SQL Server 2008 R2 and Visual Studio 2010 Premium however I do not get the option of Integration Services project template.
I have Visual Studio 2012 installed but it is my understanding that VS2012 cannot be used for SSIS package creation.
Best Answer
You need
Business Intelligence Development Studio (BIDS)if you want to create SSIS packages with SQL Server 2008 R2 version. BIDS uses Visual Studio 2008 Shell. Visual Studio 2010 is not required for SSIS development with SQL Server 2008 R2.However, if you are using SQL Server 2012 then you need SQL Server Data Tools (SSDT) which uses Visual Studio 2010 Shell.
Answer to the below SO question contains the steps to install Business Intelligence Development Studio (BIDS) using SQL Server 2008 R2 installer.
How do I enable Integration Services (SSIS) in SQL Server 2008?