February 25, 2014 at 8:05 am
how can we identify whether the SSIS installed is 32 bit or 64 bit ?
also we need to install 32 bit on a 64 bit machine how can we install ?
February 25, 2014 at 9:07 am
SELECT @@VERSIO N, if the base SQL install is 64-bit then you installed SSIS as 64-bit
Ex: Microsoft SQL Server 2008 (SP3) - 10.0.5512.0 (X64) Aug 22 2012 19:25:47 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)
If you have a 64-bit server the easiest method is to determine whether or not the binaries are installed in "C:\Program Files" or "C:\Program Files (x86)" If (x86) then they are installed as 32-bit, if not then it's 64-bit
Assuming this is 2008, to install 32-bit SSIS you may be able to spin up the SQL setup from a 32-bit env (haven't actually tried this) and choose the Integration Services option from the feature list...
Why would you want to install a 32-bit version if you are running a 64-bit OS?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply