Post reply

Allocate memory error for SSIS connection

  • October 12, 2011 at 8:08 am

    #249161

    Hi,

    We have a consultant working on setting up a process to transfer data from SQL Server to Oracle. When he tries to use a connection manager to Oracle in SSIS, he gets the error "Test connection failed because of error in initializing provider. ORA-01019; unable to allocate memory in the user side." The connection works fine for me.

    I'm assuming this is a permission issue, but I don't work to grant him admin rights on our server. Is there anything else I can do?

    Thanks.

  • 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?

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply