Cannot lock request 254,023


  • Hi,

    I have been running SSIS job for loading 26 million records from SAP source to SQL Server table having 20 columns. there are no transformations in my DFT.

    after DFT i have Execute SQL Task to get the target count.

    26 million records have been successfully inserted into the table but job failed with below error:"Source: DFT_BW_TO_STAGING SAP BI Source     Description: Cannot lock request 254,023  End Error  DTExec: The package execution returned DTSER_FAILURE (1)."

    What could be the reason behind this result.

    Any help would be greatly appreciated.

    Thursday, September 2, 2010 6:51 AM

All replies

  • Are you doing any deletion here?


    What is the driver you are using to connect with SAP.


    "Cannot lock request" is the one from SAP.

    Thursday, September 2, 2010 10:49 AM