You can create and use a hostname with No-IP to run an FTP server.
In addition, by using the commands listed above versus a two step process the overall code may be a little bit cleaner.
A second consideration with SQL Server 2005 is that the Surface Area Configuration setting must be enabled to use this code in either case.
Prerequisites For all of these examples, please do the following: General Analysis In terms of transitioning your code to the new approach, I have yet to experience any performance issues with 1000's of records, but that seems to be the first concern.
If you test the approach and the overall performance is not an issue, then consider the approach.
Are their any benefits to transitioning our code to another approach with the OPENROWSET command?