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.Das
View Complete Post