March 14, 2014 at 8:32 am
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
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
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?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply