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
Pranam BhatPosted Jun 11, 2021, 6:24 AM
https://www.sqlshack.com/execute-sql-tasks-in-ssis-output-parameters-vs-result-sets/
https://www.sqlshack.com/ssis-conditional-split-transform-overview/
https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/ssis-basics-using-the-execute-sql-task-to-generate-result-sets/