Hi, I’m looking for the best way to create a staging table in SQL using Execute Non query. I’ve imported data in to an existing SQL table previously, but never created a staging or temp table in SQL through UiPath.
Does anyone have any experience with this?
I’m assuming i’d initially have a datatable containing columns and rows ready for import. After that create the staging table (somehow), then for each row within the datatable use a stored proc to pass that in to the staging table.
Am I on the right lines? Any pointers on the staging table?
Thanks in advance!