asked
SSIS Design in Visual Studio 2012
Can I create an SSIS package for SQL Server 2012 in Visual Studio 2012 (64bit). If so does anyone have a link to the download?
You can download SQL Server Data Tools (SSDT) for Visual Studio 2012 here - [
http://msdn.microsoft.com/en-us/jj650015][1] I've installed it, but still can't create packages with Visual Studio 2012. Visual Studio 2010 seems to be the working environment for SSDT and SQL Server 2012. [1]:
http://msdn.microsoft.com/en-us/jj650015
Thanks KenJ. I downloaded SSDTSetup.exe and installed and nothing changed in VS2012 which confused me. It turns out that Microsoft have decided to confuse the hell out of everyone. SSDTSetup.exe only updates the database project templates and not the BI tools. I read various articles and discovered that what I needed was SSDTBI_V2012_x86_ENU.exe. After finding a number of Microsoft pages containing broken links I found this link
http://download.microsoft.com/download/5/C/4/5C4AFD6F-C26F-4E3A-8BE9-8AC43F9039E3/SSDTBI_VS2012_x86_ENU.exe. The installation was progressing well but failed with a 'Same architecture installation' error. The OS is Windows 8 64 bit and I have SQL Server 64 bit. The SSDTI package has x86 in the title but claims it will run on 64bit but I guess something is wrong somewhere.
In the original installation I chose to add features to my existing installation which failed. Having read the following
http://support.microsoft.com/kb/2000404 it turns out that I need to select 'New Standalone Installation' to get around the compatibility issues, this does not create a new instance just installs the BI components side by side.
14 People are following this question.
