Hi,
I have a stored procedure that generates a table variable. How am I able
to export the result of that table variable to an excel file. I don't see
any function in Transformation Task that allows to run any stored procedure.
All I can choose from Transformation Task is a table or a view.
Thanks
Ed

Can you not change this to a table valued function and do

SELECT <col list> FROM dbo.FuncName(Params)



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Ed" <Ed (AT) discussions (DOT) microsoft.com> wrote

Yes, it works fine by using table valued function
I would like to make sure I could not use table variable or temp table to
export out to text or Excel file by using Transformation Task, is that true?
Thanks Allan
Ed

"Allan Mitchell" wrote:

If I was doing this in an SP I would

SET NOCOUNT ON

And do a SELECT at the end.

Temp tables are a pain and ++ you incur recreate costs and maybe even plan
recompilations as well.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Ed" <Ed (AT) discussions (DOT) microsoft.com> wrote