I have a 14mb text file that is being FTP'd down to my hosted
web site. I
need to put the contents of the file into a ms sql table.
I tried every way to connect to this file remotely (Sql and
web server are
on different boxes) through DTS MSSQL.
I had no luck and couldnt find any info on google about
connecting to the
remote text file so I have resorted to use coldfusion to
handle the bulk
table insert. I know, I know, Yuck!!