Post reply

Invalid access to memory location. (Exeption from HRESULT: 0x800703E6)

  • June 6, 2011 at 3:02 pm

    #251298

    I'm getting the following error when I try to import an SSIS package as a Stored Package on SQL Server. I get the prompt asking me if I want to overwrite the existing file but then it gives the following error:

    Invalid access to memory location. (Exeption from HRESULT: 0x800703E6)

    (Microsoft.SqlServer.ManagedDTS)

    I've tried running the following but still no remedy:

    Regsvr32 msxml3.dll

    Regsvr32 msxml6.dll

  • June 8, 2011 at 7:36 am

    #1335650

    Can you manually create a new file in the location specified?

  • June 8, 2011 at 7:54 am

    #1335661

    Yes, I tried creating a simple ssis package and recieved the same error.

  • June 8, 2011 at 8:53 am

    #1335699

    At a guess i would say its a rights issue rather then a hardware issue.

    Having never imported an SSIS package as a SP i am assuming that the package is saved in a file location. Find this location in explorer and make sure that the SQL account can write to this location.

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

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