Fast or not, using SSIS 32 bits comparing with 64 bits

• sqlfriend

  SSC Guru

  Points: 52769

  More actions

  September 14, 2012 at 3:17 pm

  #264280

  I wonder if run a ssis package using 32 bits on a 64 bits server, will it runs slower than 64bits ssis?

  Or it doesn't make much difference.

  I am running 32 bits because I am using a data provider which has 32 bits.

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  September 20, 2012 at 3:54 am

  #1539957

  It depends on the load of your package and what you exactly do in the package, but I don't think you'll see much difference.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP