Forum Discussion

rupam9191's avatar
rupam9191
Icon for Microsoft rankMicrosoft
Jul 12, 2020

Is table valued parameter allowed in stored procedure activity ?

I am trying to pass a table from a lookup activity to stored procedure activity , which executes a sproc with table valued parameter. 

But Stored procedure activity, doesnt seem to have table type when clicked on import schema 

Is it not supported ? Do I need to do some manual mapping ?

No RepliesBe the first to reply