question

tanglesoft avatar image
tanglesoft 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?
ssissql-server-2012ssdtvisual-studio-2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image
KenJ answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

tanglesoft avatar image
tanglesoft answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

tanglesoft avatar image
tanglesoft answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.