Here is the Problem
There is a excel which having the data
i want to create a store procedure that read the excel data and save this data to temp table.
after that it save the data to main table.
and after save into the main table, SP now truncate the temp table.
can anyone write the code of SP and tell me how to use this SP in process model
Thanks
Discussion posts and replies are publicly visible
First import the data from excel file to a temporary table using "Import Excel to Database" smart service.
Create a stored procedure that has the SQL statements that takes the data from temp table to main table (You can also use an Appian process to do that)
At last use the truncate statement in Stored Procedure to drop the contents in the temp table.
In the process model call the stored procedure using Execute Stored Procedure smart service