SSIS 64 Bit Environment
I am working on SSIS migration from 32 bit server to a 64 bit server, I had a few doubts with regards to the same:
1. Are there differrent versions of SSIS present, which owuld be installed with each SQL installation, or its just that SQL server is installed and its intelligent enough to recognise thats its bein installed on a 64 bit server so its runs optmized to that
environment, I know that drivers are required but here am talking about SSIS environments specifically.
2. Is there some setting on the packages which will make them run on the 32 bot mode at runtime even on a 64 bot server, have noticed a specific SSIS project property which allows setting the running mode to 64 bit to treo or false.
3. Can i do some setting at the package level which would force my package to utilize the 32 bit drivers for connections managers on a 64 bit server.
Oveall i want to know how does a pakcage knows thats its being run on 64 bot env to utilise the 64 bit environemnt or 32 bit environmnent, cna some either direct me to some links or explain this in details
I am using SQL Server 2005, and SQL Server 2008,
Abhinav
January 31st, 2011 2:15pm
Here are couple of links links
http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx
http://msdn.microsoft.com/en-us/library/ms141766.aspx
Thanks
Aamir
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 2:49pm
1. SSIS is part of SQL Server BI Suite. Therefore, on a 64-bit machine you need to install the 64-bit version of SQL Server.
2. Yes, there is. right-click on the project entry in Solution Explorer in BIDS, and select Properties. Then in Debugging tab, set Run64BitRuntime to false.
Please mark as answer if this helps. Thank you!
http://thebipalace.wordpress.com
January 31st, 2011 9:33pm
But this is for instant debugging, and is a project level setting not package level, once pacakges are installed they are individauln in the sense that the pacakge properties are the one which works, i was wondering about how does the
specific project knows which environemnt to use....
Is it that it just uses the environment its running on, I have read the documentaiton a bit and can understand that there might be both the 64bit and 34 bit environment on the same server, in such a case what is it in the specific package which make it utilise
some specific environemnt.Abhinav
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2011 7:14am
Abhinav,
Yes, the option to run your package in 32 Bit mode will remain, further to this:
In some situations (package dependant, and in most cases when you do not have the 64 bit drivers, the most notable probably is the MS Office, you NEED to run a package in 32 bit mode).
If you execute packages using the SQL Agent then you may need a "use 32 Bit" mode by applying the /x86 flag.
if you run packages using DTExec then it relies on the PATH environmental variable.
If the path to the 32 bit DTExec utility happens to be in front of the 64 bit counterpart then the the 32 bit execution will occur.Arthur My Blog
February 2nd, 2011 10:06am
This should be a complete description of the issue, and answer all the questions you had:
SSIS in 32- and 64-bits.
Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2011 11:07am