When I attempt to use a user defined stored procedure for the source of a
Transform Data Task or DDQ task I get an error message that states that no
rowset in returned from the stored procedure.
I need to use a declared table to remove invalid rows before processing.

here's how I created the sp.

CREATE PROCEDURE [dbo].[usp_test] AS
begin
declare @t table
(
id int primary key
)

insert into @t
select id from sysobjects

select id from @t
end


GO

Try doing this at the top

SET NOCOUNT ON

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Darren" <deo.is (AT) unknown (DOT) com> wrote

Thanks!
I had a workaround using a user function that returned a table but it's nice
to know why the sp didn't work.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote