i'm calling a stored procedure to generate a dataset for importation across
sql servers. the stored procedure uses a temp table. when trying to set up
the dts package, i get an error message "invalid object #temptablename"

what's going on here? can i just not use temp tables in sp's that get
called from dts packages? is there a standard workaround? or am i just
doing something wrong?

thanks
matthew

If you want to use a # table then what I do is I create it inmy database
just before I design the package so that it know about it and can do all the
maping things



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"matthew c. harad" <matthewcharad (AT) discussions (DOT) microsoft.com> wrote in
message news:16F46593-7207-4D93-9AA5-4F74682C163F (AT) microsoft (DOT) com...

I have had the same issue, Even if you have a sqltask that
creates the table, the temp table is not available to the
dts package because it is created and dumped once the
connection is closed.
Is there some connection property to use to hold open the
connection?