Prince Jain

Prince Jain

  • 1.9k
  • 66
  • 660

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

How I will pass these records to spWriteData as parameter 


Answers (1)