import html file error

#1

Im trying to import an html file using dts. When I click on the file when
using dts designer, I get the message:

External table is not in the expected format.

Any ideas?

--
SQL2K SP3

TIA, ChrisR

#2

In message <udOcQh54EHA.936 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, ChrisR
<bla (AT) noemail (DOT) com> writes

Quote:

Im trying to import an html file using dts. When I click on the file when
using dts designer, I get the message:

External table is not in the expected format.

Any ideas?

--
SQL2K SP3

TIA, ChrisR

Does the error not say it all? The HTML connection cannot
parse/recognise a valid html table in that file. No table, no import.

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

import html file error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

import html file error - 12-16-2004 , 11:55 AM

Re: import html file error - 12-16-2004 , 12:41 PM