Solved

Error in Data Load Run - FACT_GL_TRANSACTION

  • 20 March 2024
  • 1 reply
  • 19 views

Badge +2

Hello,

We have a data source - FACT_GL_TRANSACTION which needs to be sent as incremental load to Azure. But the load goes into error while the data load runs. Any idea why ?

 

 

icon

Best answer by subashfestus 20 March 2024, 06:13

View original

1 reply

Badge +4

Hi @AccManisC,
Check the SSIS logs for the failed SSIS execution ID using the view catalog.event_messages in SSISDB. That will be helpful in identifying the issue. You can find the “SSIS execution ID” from the “Data Load Run Items” list.

 
You can also use the IFS application to get the logs as described in the following techdoc page but the above way is more efficient.

https://docs.ifs.com/techdocs/23r2/050_reporting/600_analysis_models/060_configdataload/#immediate_execution

Reply