I have been running SSIS job for loading 15 million records from SAP source to SQL Server table having 20 columns. there are no transformations in my DFT.After loading 1 million job has been failed with below error. did anyone has faced this
Source: DFT_BW_TO_STAGING SAP BI Source Description: Cannot lock request 257,488 End Error Error: 2010-09-18 00:39:39.86 Code: 0x000003E8 Source: DFT_BW_TO_STAGING SAP BI
Source Description: System.Exception: The component could not create a new internal table. hIT=-1885983488 at Microsoft.SqlServer.Dts.SapBw.Connectivity.RFCFunction.Execute() at Microsoft.SqlServer.Dts.SapBw.Components.OHSExtractor.ExtractNow(Boolean
InRuntimeMode, String GatewayHost, String GatewayService, String ProgramID, String ProcessChain, String DestinationName, String ExecutionMode, String PropertyRequestID, Int32 Timeout)
What could be the reason behind this result.
Any help would be greatly appreciated.Das
View Complete Post