Prince Jain

Prince Jain

  • 2k
  • 53
  • 557

How to pass multiple records to procedure using SSIS service?

Jun 10 2021 6:04 PM

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)