import html file error

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, ChrisRIn message <udOcQh54EHA.936@.TK2MSFTNGP12.phx.gbl>, ChrisR
<bla@.noemail.com> writes
>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

Import external data

Hi friends,
I want to import data from remote database(oracle) to my sql
server
local database.
As one of the group mate suggested I used Import(Tasks -> Import)
Its ok. But I want this to be done for a frequent of times and put in
a schedule. How can I do this.
And every time I import, the duplicates will not be imported I mean
the old data will not be imported again. ONly the current data to be
imported.
How can I make schedule and not alowing to import old records again?
Thanks in advanceMake a linked server and a stored procedure that pulls the data using a NOT
EXISTS clause. Then create an agent job on sql server to run it on whatever
schedule you desire. The same can probably be accomplished using SSIS as
well.
<mrajanikrishna@.gmail.com> wrote in message
news:1190732099.352879.45570@.y42g2000hsy.googlegroups.com...
> Hi friends,
> I want to import data from remote database(oracle) to my sql
> server
> local database.
>
> As one of the group mate suggested I used Import(Tasks -> Import)
> Its ok. But I want this to be done for a frequent of times and put in
> a schedule. How can I do this.
>
> And every time I import, the duplicates will not be imported I mean
> the old data will not be imported again. ONly the current data to be
> imported.
>
> How can I make schedule and not alowing to import old records again?
>
> Thanks in advance
>