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 ?
Solved
Error in Data Load Run - FACT_GL_TRANSACTION
+2Best answer by subashfestus
Hi
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.
Hi
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.