How to pass datatable as a parameter in sql Store procedure

[neerajmca5 (Neeraj Yadav)]

Hi All,
I have excel data into datatable now i want to pass datatable to the sql store procedure as a parameter .
Please help me .

Thanks in advance.

[muhammedyuzuak]

Hi @neerajmca5,

Welcome to community.

You can follow the steps.

How to execute stored procedure in uipath?

Use Execute query activity under Database. If it is not available install the UiPath.Database.Acitivities package.Use configure connection and connect to DB. In properties Fill the SP name against SQL. In Parameter pass input values with direction IN. Choose command type as Store procedure You can Store the return output in a DT variable if needed. [image]

Regards,
MY