sql server dts: Ive tried several ways to create a DTS package to import a text file into my
SQL database from a remote web server (ip address).

When i walk through the text file wizard I've tried the following paths for
the connection but it keeps failing. My permissions on the webserver are ok
because you can enter the address in abrowser without any problems.

//208.106.197.112/book1.csv

http://208.106.197.112/book1.csv

How do i connect to a remote text file so I can import its contents into a
table? Should I be using a different connection

Hi,

I think you can't connect to an HTTP adress using Text File Source in
DTS.

I had this kind of problems solved in three different ways, depending
on the project dependancies :
- Mapping a new network drive
- Copying the file on a local drive (this was used on a FTP website)
- Using VBScript to read an HTTP stream...

Good luck.

C=E9dric Del Nibbio
MCP since 2003
MCAD .NET
MCTS SQL Server 2005



bj a =E9crit :

[quoted text, click to view]