I created a DTS import that copies data from and excel file to a SQL2000
table. In the vb code there is a DTSDataPumpTask being created and then a
SELECT statement that is selecting all the data to be copied. IN the SELECT
statement in the FROM clause there is a reference to what I thought was the
Excel sheet name. However, when I changed the sheet name in the excel file,
everything still ran correctly. I want to change this table_source name in
the vb code, so what do I need to do?

The SourceObjectName should be the object you are looking for. The object
is not the Sheet necessarily rather the named range (table). You can have
multiple named ranges per worksheet.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Eddie Suey" <esuey (AT) inBizServices (DOT) com> wrote

There was no assignment to the object SourceObjectName in the
auto-generated file. But, I added one and it worked great! Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!