Create Staging table in SQL using Execute Non Query

Help
, , ,
1

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
2

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

1 Like
3

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

4

I faced the same requirement and did not find a solution in this forum.
Therefore I created a workflow inspired by article in stackoverflow

Making it available for the comunity
BuildSqlTable.xaml (16.1 KB)

Cheers