Import parameter (Table type & Table type parameter name) for stored procedure in Azure Data Factory

Question

I am trying to figure out what to put here:

Currently, I am just trying to run a stored procedure to test out.
First task is truncate table:

I am not sure this would help, but when I execute this stored procedure, this is output:

Answer 1

If the SP just has truncate table statement, you can avoid using this SP and use pre-copy option. This way, first data will get truncated before copy and later data will get loaded to target table which is selected in Sink dataset.

Also see this - https://azurelib.com/truncate-table-before-copy/

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

If you have no parameters in the stored procedure, then removing them would suffice... if the long term intent is to provide a generic stored procedure then that may come in handy and I think you can still run the process with those values left blank... or random as you see fit

How did they get in there? Are you possibly pointing to a different database (where the stored proc already exists) to where you expect?

Answer 3

@Ryan Abbey
If there is no existing stored procedure, then, you select none.

If you select none, then those options (Import parameter - Table type and Table type parameter name) do not show up.