Post reply

SSIS - Network Map - Connection Manager Fail

  • March 14, 2014 at 8:32 am

    #284589

    I am running SQL Server 2012 on a VM and am trying to pull data from a network drive (S: or \\misvnascfs0003\)

    I can import data using the Import Wizard and save the package as an SSIS package. When I try to Run the Package I get The Acquire Connection method call to the connection manager "SourceConnectionExcel" failed with the error...

    If I save the file to the VM local drive the SSIS package run fine.

    Is there a work around for this?

    When I log into SSIS through SSMS i have to run as "Administrator".

  • March 14, 2014 at 10:02 am

    #1697199

    Could be due to missing 64 bit drivers for Excel ? Try to change the setting Run64BitRunTime property as False in the SSIS package and Run.

    Or else you install ACE OLEDB driver ..

    --

    SQLBuddy

  • March 14, 2014 at 2:54 pm

    #1697332

    jeandlauro (3/14/2014)

    I am running SQL Server 2012 on a VM and am trying to pull data from a network drive (S: or \\misvnascfs0003\)

    I can import data using the Import Wizard and save the package as an SSIS package. When I try to Run the Package I get The Acquire Connection method call to the connection manager "SourceConnectionExcel" failed with the error...

    Could you provide the exact error message/number?

    jeandlauro (3/14/2014)

    If I save the file to the VM local drive the SSIS package run fine.

    This isolates the issue with file binaries( like excel etc..) , using SSIS task could you try reading a text file from network drive.

    Did you map the network drive? manually or automatic?

    check here: Mapped Drive Connection to network may be lost

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

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