SQL 2000

I got a table with file names and path for the Excel files to be loaded into
a sql table.
My plan is to use DTS and global variable to assign the path and file name
and use that as the source for the data-pump.

Any thoughts or sample code to achieve this ??

Thanks In Advance
Jeff

You would probably want to have a look at these two articles then.

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

--



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


"MS User" <sqlman (AT) sql (DOT) com> wrote

Thanks Allan

My Excel sheet contains different sheets and I just want to read one sheet
to load into table. Thoughts/Ideas ??

Thanks


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

The worksheets/named ranges within a workbook will be exposed to DTS as
table objects.
So this will give you the ability to change the DataSource property of the
Excel workbook and the SourceObjectName of the DataPump task.



--



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


"MS User" <sqlman (AT) sql (DOT) com> wrote

Thanks Allan. That did it.


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