I have an URL to a file that is comma separated on the web. I would like to
use DTS to put the contents into a table. When I create an HTML file source
and give the URL as the location I get the following error:

Error Source : Microsoft JET Database Engine
Error Description : Cannot update. Database or object is read-only.

It's obviously read-only because its a webpage on the internet. Maybe I'm
missing the point of this type of source connection? Can someone suggest how
to simply get this comma separated webpage into a table in SQL Server,
without using scripts or Excel web queries, etc.?

If the file is delimited just use the file name as the source in a regular
text file and not use it as an HTML file.


"Kyler" <kyler (AT) discussions (DOT) microsoft.com> wrote

Hi Rick,
Thanks for your reply. I have tried using a 'Text File (Source)' instead of
a 'HTML File (Source)', however it doesn't seem to work with a URL.

Try to create an ActiveX script that will copy the file locally before you
try an import. Once it is imported then create another ActiveX script to
delete the local copy of the file or move it to another folder to keep an
archive copy of the file.

Rick

"Kyler" <kyler (AT) discussions (DOT) microsoft.com> wrote