none
SSIS loading Excel validation error? RRS feed

  • Question

  • I created a package loading Excel file. I developed the package using test excel file c:\Test\Test.xls and use a config file to assign actual folder (the file names will be got from a foreach loop container) when run it.

     

    However, the package cannot run with a configure file which specify a different source folder and still ask for test.xls. It's not possible that it require reset the folder and file every time when it's used for a new folder.

     

    Information: 0x40016041 at Package1: The package is attempting to configure from the XML file "C:\working\Final3.dtsConfig".
    SSIS package "Package1.dtsx" starting.

    Information: 0x4004300A at Load Raw1, DTS.Pipeline: Validation phase is beginning.

    Error: 0xC0202009 at Package1, Connection manager "Excel Connection Manager": 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: "The Microsoft Jet database engine could not find the object '\\SourceFolder\Test.xls'.  Make sure the object exists and that you spell its name and the path name correctly.".

    Error: 0xC020801C at Load Raw1, Excel Source [1188]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    Error: 0xC0047017 at Load Raw1, DTS.Pipeline: component "Excel Source" (1188) failed validation and returned error code 0xC020801C.

    Error: 0xC004700C at Load Raw1, DTS.Pipeline: One or more component failed validation.

    Error: 0xC0024107 at Load Raw1: There were errors during task validation.

    SSIS package "Package1.dtsx" finished: Failure.

    Thursday, September 20, 2007 9:10 PM

Answers

All replies

  • Set DelayValidation = True on the connection manager and the data flow.

    Saturday, September 22, 2007 5:19 AM
    Moderator
  • Hello jwelch,

     

    I have the same problem,  actually I change the property DelayValidation on the excel connection manage, the dataflow and over the package.  And really I still have the problem.  If I disable the configuration file in the menu SSIS>Package Configuration the package work fine.  I note that the problem begin when i try to change the user that run the package.  If I try to run the package with the user created the package work fine.

     

     

    Do you have some comment about that?

     

     

     

     

     

     

    Thursday, May 22, 2008 3:34 PM
  • Have you verified that the new user account has permission to access the file referenced in the configuration account?

    Thursday, May 22, 2008 3:43 PM
    Moderator
  • Yes, he is Administrator group in the machine also I gave all control over de file referenced in the configuration account

     

    Thursday, May 22, 2008 5:00 PM
  • Can you post the complete set of error messages you are getting?

    Thursday, May 22, 2008 5:50 PM
    Moderator
  • Hi there,

    If it still does not work, check to see if you have the package sensible information, encrypted to the user package creator (package properties), this inhibits another user to run the package (safety issues).

    Hope it helps,

    Bruno


    Bruno Pimenta
    Friday, March 5, 2010 3:09 PM
  • Did u get it solved,as I am facing the same problem
    Tuesday, December 12, 2017 10:47 PM