1
Answer

How to pass multiple records to procedure using SSIS service?

Prince Jain

Prince Jain

3y
458
1

I have a procedure ReadData which fetch the data from one database 

and  want to pass all the records in spWriteData procedure  using SSIS ?


I wrote a procedure using table type 

CREATE PROCEDURE [dbo].[spWriteData]
@Parameter [dbo].[UserDefinedTableType] READONLY
AS

How I will pass these records to spWriteData as parameter 

 

Answers (1)