Entering the contents of a remote notepad file via ColdFusion 8 into an SQL Server 2005 database
Posted on 2008-11-07
I have a notepad file with about 50,000 lines. Each line consists of a six digit number that must be entered into a field in a table in a an SQL Server 2005 database.
I am tempted to simply create an ftp connection to the file, and then process its content line by line, but I suspect that might be a little slow.
Can anyone suggest a more efficient way to do this?
Bear in mind that the technologies being used are:
1) ColdFusion Server 8.0
2) SQL Server 2005