Hello Team,
I created an SSIS Package to load data from SAP BW to SQL SERVER. The package is running fine but failing in SQL Agent Job. Below is the Error.
ERPConnect.ERPException: Could not find attribute 'Name' in node 'HierarchyLevels' at ERPConnect.RFCSoapProcessor.GetAttributeValueFromNode(XmlNode node, String AttributeName) at ERPConnect.BW.BWCube.XMLToHierarchiesCollection(BWCube cube, XmlNode node, HierarchyCollection parcol) at ERPConnect.BW.BWCube.XMLToDimensionCollection(BWCube cube, XmlNode node, DimensionCollection parcol) at ERPConnect.BW.BWCube.InnerLoadFromXML(XmlDocument xdoc) at XtractIS.XtractSourceBWQuery.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket) End Error Error: 2021-01-13 12:46:26.93 Code: 0xC0047038 Source: Extract Data from POA SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Xtract BW Cube" (4157) returned error code 0x80131500. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:46:25 PM Finished: 12:46:26 PM Elapsed: 1.903 seconds. The package execution failed. The step failed.