I've been trying to figure out how to do the following task for about 1/2 a
day now. I have a text file that is downloaded from our inventory mainframe
system to our web server. Anyone can browse the file at the moment as the
root of our hosted web server has public access (I'll change its location
for security when i have it working)

http://209.200.116.72/products_brett.txt

I want to schedule a DTS package to insert the contents into my SQL database
table. I walk through the import wizard to start setting up the process and
I select "text file" as the datsource. Then for filename i select
\\209.200.116.72\products_brett.txt

Regardless of what UNC path i put in, the connection fails. I get the
following error
"Could not open file for reading. Close any other application that may be
locking the file"
I have tried the following paths
\\209.200.116.72
//209.200.116.72/products_brett.txt

Am I going about this the wrong way? Should I be using some other
datasource?

I posted this on another forum and i was advised that it could be a sharing
problem on the web server. I find this weird as my root folder on my web
server has read access for everyone. As i mentioned, you can view the
contents of the file through any browser. Im confident the insert will be ok
its just this initial connection to the remote file.

Any help appreciated.