Hello,

I have a DTS package that needs to export the results of a
stored procedure into an Excel spreadsheet. The stored
procedure is returning results from global temporary
tables.

I have a transform data task. The source tab contains the
stored procedure name. But on the transformations tab, I
cannot get the Source column names to show up.

Does anyone know how to fix this?

Thank you so much!
Melanie

In article <0d2701c3a474$c2e428c0$a301280a (AT) phx (DOT) gbl>, Melanie
<anonymous (AT) discussions (DOT) microsoft.com> writes
The global temp table needs to exist for the meta-data to be available.
Run the proc manually and ensure you do not drop the tables, then build
the package. Once the design is complete you can drop the temp table and
also allow the proc to clean up itself. Just fudge it for the designer
temporarily.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hi Darren,

Thank you for your recommendation. I tried the creation
of the global tables (just by running the CREATE TABLE
code in my procedure) while trying to design this DTS
package but that didn't work.

I haven't tried running the procedure without dropping the
tables, so I'll try that. Maybe I need to have actual
data in there.

Thanks!!
Melanie

Hi Darren,

THANK YOU SO MUCH! Running the procedure without dropping
the global tables worked (I guess I did need actual data
in these tables).

Much appreciated!
Melanie

In article <02ab01c3a4a5$a5839910$a401280a (AT) phx (DOT) gbl>, Melanie
<anonymous (AT) discussions (DOT) microsoft.com> writes
Shouldn't need the data, are you sure you didn't close the connection
after the create table which would drop the ## table?

Either way, glad it now works.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org