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,

There is no bit-ness stored in the SSIS package. 

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

HI All,

I am using Sql server 2012 and my Excel is currently 32  bit but  i want to run that package in 64 bit .

Is it possible to run that package in 64 bit ...

can we convert export to 32 bit to 64 bit or any setup we have to use for that?

• Edited by Lukesh Sahu 25 minutes ago

SSIS use the ACE data provider to access MS Excel files. If you have MS Office installed as 32 bit version, then you have also installed ACE as 32 bit and the SSIS package must run in 32 bit mode.

If you want to run the package in 64 mode, then you have to uninstall Office completely and install ACE as 64 bit version; there is no other way around.