views:

2507

answers:

1

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

A: 

Is it maybe getting the result of the insert statement? Try SET NOCOUNT ON.

http://msdn.microsoft.com/en-us/library/aa259204(SQL.80).aspx

Sam