Thursday, April 14, 2011

ssis : how to insert into oledb destination from oledb command

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

From stackoverflow

0 comments:

Post a Comment