Is table valued parameter allowed in stored procedure activity ?

Microsoft

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 ?

0 Replies