Hi I'm trying to insert in a ole db destination the result of a sp for each record in an ole db source,
the sp returns a record set
I have found this how to call a stored procedure in SSIS
but i still can't see the outpout columns in OleDb Command Output Columns
here is my sp: create PROCEDURE [dbo].[GetData] ( @user varchar(50) ) AS set nocount on -- Publish metadata for ssis if 1=0 begin select '' x, '' y, '' z end
declare @user_tmp table ( x varchar(max), y varchar(max), z varchar(max) )
insert into @user_tmp select 'x1' x, 'y1' y, 'z1' z
select distinct * from @user_tmp set nocount off