March 4, 2017 at 5:01 pm
Hi,
I searched all the blogs to find visual studio 64 bit version. Do we have 64 bit visual studio version. Where Can I find 64 bit SQL Server Data Tools.
For SQL server 2012, SQL server Data Tools are available in installation media. If we install SQL server Data Tools along with SQL server 2012 X64 bit version. Then the installed SSDT will be of 64 bit?
Looking forward for your help.
March 4, 2017 at 5:11 pm
VS is only 32 bit and so is SSDT (as this is nothing else than extensions to VS).
Normally this is not an issue as most of the common drivers used within SSDT have both 64 and 32 bit version.
In some cases in order to execute and debug a SSIS package you do need to force the project to run in 32 bit mode. However this does not prevent that when you are executing the package either on SSISDB or on the command line from using the 64bit engine version (as long as you have the 64bit version of any software you may use on your packages installed)
March 6, 2017 at 5:53 am
frederico_fonseca - Saturday, March 4, 2017 5:11 PMVS is only 32 bit and so is SSDT (as this is nothing else than extensions to VS).Normally this is not an issue as most of the common drivers used within SSDT have both 64 and 32 bit version.
In some cases in order to execute and debug a SSIS package you do need to force the project to run in 32 bit mode. However this does not prevent that when you are executing the package either on SSISDB or on the command line from using the 64bit engine version (as long as you have the 64bit version of any software you may use on your packages installed)
Just elaborating on this a little. When you debug a package in SSDT, by default a 64-bit process is spawned to execute the package. So although you are doing your development in a 32-bit world (devenv.exe) that is not the way that the package runs (unless you specifically force the project to run in 32-bit mode).
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply