Hello all, I have an SSIS package that imports data from an Excel spreadsheet that's stored in Sharepoint. When I run the package manually through Visual Studio (pointing to the Excel file in Sharepoint using it's UNC path), it runs successfully. I created a job that kicks off the SSIS package using a Proxy account to "Run as" my windows account. When I run that job, it fails (pointing to the Excel file in Sharepoint using it's UNC path) with the error message listed below. When I run that job (pointing to a copy of the Excel file on my local computer) it succeeds. My windows account has full permissions on the Sharepoint site as does the SQL Service account. Any ideas? Thanks! Matt Message Executed as user: DEV\EPUASMMW. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:51:09 PM Error: 2011-02-11 16:51:10.32 Code: 0xC0202009 Source: ImportAugmentationTemplate Connection manager "ExcelImportFile" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Failure creating file.". End Error Error: 2011-02-11 16:51:10.32 Code: 0xC020801C Source: Import AugmentationTemplate spreadsheet into DB Excel Source [143] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ExcelImportFile" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2011-02-11 16:51:10.32 Code: 0xC0047017 Source: Import AugmentationTemplate spreadsheet into DB SSIS.Pipeline Description: component "Excel Source" (143) failed validation and returned error code 0xC020801C. End Error Error: 2011-02-11 16:51:10.32 Code: 0xC004700C Source: Import AugmentationTemplate spreadsheet into DB SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2011-02-11 16:51:10.32 Code: 0xC0024107 Source: Import AugmentationTemplate spreadsheet into DB Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:51:09 PM Finished: 4:51:10 PM Elapsed: 0.969 seconds. The package execution failed. The step failed.

Hi, Have you checked the permissions on the remote server for the user that runs SSIS package? Is the remote server 64-bit or 32-bit? have a look at this page if the target machine is 64-bit: http://hrvoje.piasevoli.com/2010/09/01/importing-data-from-64-bit-excel-in-ssis/ Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

This most probably is an issue pertaining to the Temp directory access rights. To resolve this issue, you must change the permissions for the Temp directory of the SQL Server Agent Service startup account. Grant the Read permission and the Write permission to the SQL Server 2005 Agent proxy account for this directory. Full publication on this is at http://support.microsoft.com/kb/933835Arthur My Blog

Hi, Have you checked the permissions on the remote server for the user that runs SSIS package? Is the remote server 64-bit or 32-bit? have a look at this page if the target machine is 64-bit: http://hrvoje.piasevoli.com/2010/09/01/importing-data-from-64-bit-excel-in-ssis/ Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Thanks for the advice! Which specific Temp directory are you referring to? C:\Temp?

it is the system %TEMP% directory. You can get to it by simply typing in %temp% in the command prompt or Run menu.Arthur My Blog

it is the system %TEMP% directory. You can get to it by simply typing in %temp% in the command prompt or Run menu.Arthur My Blog

Did Arthur's advice solve your problem? I'm so curious about that.. Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Did Arthur's advice solve your problem? I'm so curious about that.. Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Hi Arthur, I just gave the SQL Server 2005 Agent proxy account read/write permissions to the %TEMP% directory (c:\windows\temp). It didn't fix the problem. :( I'm still getting the same error... "Failure creating file.". End Error Error: 2011-02-11 16:51:10.32 Code: 0xC020801C Source: Import AugmentationTemplate spreadsheet into DB Excel Source [143] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Any other suggestions, I'm feeling stuck.... Thanks again!

No :( Thanks for all of your help too SaeedB, I know you've been trying to point me in the right direction.

The SSIS server can't access the Sharepoint site, once we get that resolved, we should be good to go. Thanks "all" for your help!