hi,
I have few issue in SSIS. I have few packages some inn 32 bit and some in 64 bit so how can i synchronize it
can any one help me
Thanks,
Technology Tips and News
hi,
I have few issue in SSIS. I have few packages some inn 32 bit and some in 64 bit so how can i synchronize it
can any one help me
Thanks,
Hi Lukesh,
The below link will help you for sure but before migrating please consider the below factors.
http://microsoft-ssis.blogspot.in/2012/09/swtich-package-from-64bit-to-32bit.html
If the other components are in 32-bit, you need to install 32-bit only for better compatibility, even though the OS is 64-bit and vice versa. Else, not needed.
Advantage of 64-bit over 32-bit is that 64-bit releases can handle more amount of data than 32-bit due to the increased memory width.
The following links will be helpful:
http://technet.microsoft.com/en-us/library/ms141766(v=sql.105).aspx
http://technet.microsoft.com/en-us/library/aa274595(v=sql.80).aspx