Hi,
I have an EasyMorph task that has been running for some time now. (Over a year)
I am loading in Excel files based on a wildcard match of their name. Then I am doing a few transformations to get the data cleaned up. After that I am using the Custom SQL action to truncate a table and then populate the data into the empty table.
This dataset is ever growing as we get new Excel files every month. I received this error message and I’m having trouble solving the issue:
Error: Export to database has timed out. The timeout period elapsed prior to completion of the operation or the server is not responding.
Source: action "Export to database", table "Export to Test (TABLE_NAME_HERE)"
Does anyone have any advice for this?
Thanks,
Jaden
