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