Is table valued parameter allowed in stored procedure activity ?

%3CLINGO-SUB%20id%3D%22lingo-sub-1516890%22%20slang%3D%22en-US%22%3EIs%20table%20valued%20parameter%20allowed%20in%20stored%20procedure%20activity%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516890%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20pass%20a%20table%20from%20a%20lookup%20activity%20to%20stored%20procedure%20activity%20%2C%20which%20executes%20a%20sproc%20with%20table%20valued%20parameter.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20Stored%20procedure%20activity%2C%20doesnt%20seem%20to%20have%20table%20type%20when%20clicked%20on%20import%20schema%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20not%20supported%20%3F%20Do%20I%20need%20to%20do%20some%20manual%20mapping%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1516890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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