Post reply

How to execute the through SQL Server job?

  • November 15, 2011 at 3:04 am

    #246845

    Hi Friends,

    i am trying to run the package through SQL server job...But the error below is holding me ...Can any one help me,pls?

    Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-11-15 15:20:33.13

    Code: 0xC0202009 Source: Package Connection manager "Excel Connection Manager" 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: "The Microsoft Jet database engine could not find the object 'C:\Conversion\GEOConversion\Leavenworth\Data\Leavenworth GEOFILE 6-3-11.xls'. Make sure the object exists and that you spell its name and the path name correctly.". End Error Error: 2011-11-15 15:20:33.13 Code: 0xC020801C Source: SrcGcApt Excel Source [1] Description: 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. End Error Error: 2011-11-15 15:20:33.13

    Code: 0xC0047017 Source: SrcGcApt SSIS.Pipeline Description: component "Excel Source" (1) failed validation and returned error code 0xC020801C. End Error Error: 2011-11-15 15:20:33.13

    Code: 0xC004700C Source: SrcGcApt SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2011-11-15 15:20:33.13

    Code: 0xC0024107 Source: SrcGcApt Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:20:32 PM Finished: 3:20:33 PM Elapsed: 0.889 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0

    Thanks,
    Charmer

  • November 15, 2011 at 3:39 am

    #1407708

    Hi,

    The first error is probably related to the package ProtectionLevel property. Check out the following.

    http://support.microsoft.com/kb/918760

    Regards

    Daniel

  • November 16, 2011 at 3:27 am

    #1408331

    The second error says it cannot find the Excel file.

    * does the Excel file exist?

    * if it does, is it locked by some process or user?

    * does the SQL Agent user account have access to the folder where the Excel file resides in?

    * is the filepath to the Excel file static or dynamic? In other words, is this configured by an expression in the SSIS package?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 16, 2011 at 4:48 am

    #1408365

    i changed the protection level to encrypt with password...it worked out...

    thank you ...

    Thanks,
    Charmer

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

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