
Announcements
Hello all,
I'm currently working on a project that essentially requires an excel attachment to be received weekly and the data from the excel to be loaded into a Teradata table each time its received.
My flow is below but it essentially goes like this:
-Email received.
-Attachment loaded into SharePoint.
-Table created within the excel so that I can pull the data out with get rows.
- Get the rows in the SharePoint file.
-Insert each row into the Teradata table.
This flow works as intended but the insert into Teradata portion is incredibly slow since it is inserting 2000 plus rows. This number will likely grow in the future as well. I have already turned on concurrency in the "apply to each 2" step and set it to 50. I know there's ways to optimize this using SQL Server, but unfortunately SQL server tables are not an option for this project. Does anyone know of any other tricks so this doesn't take an hour to run each time?