Create Staging table in SQL using Execute Non Query

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!

1 Like

@shankm Would you be able to help with this please?
Thanking you in advance

1 Like

@PJ_17
you are looking for a temporary table or something like that?