Production: SQL 7.0 sp4
Dev: SQL 2000 sp?

I want either my named range a.k.a. table or my entire file name to be dynamic
via UI prompt.

How can I get either from the global vars?

I'm sure there must be an asp for this, but I'm too tired to sift through all
the material, I'd rather find a good one for the exact task, that will work in
7.0.

TIA

JeffP....

In message <uz30eeH5DHA.2348 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, "JDP@Work"
<JPGMTNoSpam (AT) sbcglobal (DOT) net> writes
The named range or sheet is equivalent to the table name, so to change
this you need to change the SourceObjectName property of the DataPump
task.

Changing the DataPump Source and Destination Tables
(http://www.sqldts.com/default.aspx?213)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

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

Just to follow up as well.

You can create new named ranges in Excel by issuing a CREATE TABLE statement
against the Excel connection
and then this article comes in useful.

Global Variables and SQL statements in DTS
(http://www.sqldts.com/Default.aspx?205)


--

----------------------------

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


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote