I have a Transform Data task where the source connection is SQL Server and
the destination connection is a text file. On the 'Source' tab of the task
I use a stored proc in the SqlQuery box like this:

exec dbo.xxTestTableVar

Here is the stored proc:
CREATE PROC dbo.xxTestTableVar
AS
DECLARE @tbl TABLE
(ID int)
INSERT INTO @tbl VALUES(1)
INSERT INTO @tbl VALUES(2)

SELECT *
FROM @tbl
-- END OF PROC

When I exec the proc in query analyzer it works fine. When I click on the
'Preview' button on the source tab of the transform task I get error 'No
rowset was returned from the SQL statement'. When I try to run the Task I
get an error 'Invalid Pointer'.

Thanks,
Al

In the proc do

.....
AS
SET NOCOUNT ON
....
...



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Al Cadalzo" <cadalzo (AT) hotmail (DOT) com> wrote

Allan,
You da man! Once again you save the day.

Thanks,
Al


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