Allocate memory error for SSIS connection

• SpringTownDBA

  SSCertifiable

  Points: 6917

  More actions

  October 12, 2011 at 10:47 pm

  #1393787

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/56660bac-4e2e-4a93-b1ef-5bea9728d26d/

  have you tried running it in 32 bit mode on the server?

• Linda Robinson

  Mr or Mrs. 500

  Points: 541

  More actions

  October 13, 2011 at 6:38 am

  #1393969

  It's a 32-bit system.

  We're going to create a separate development server with just the database the consultant needs, so we can give him admin rights on that. That solves our problem, but I'm still curious if one needs to be in the server admin group to develop packages in SQL Server.

  Linda