title: How to import CSV to SQL Server 2005 w/o BCP?
body: <p>I am working on a ColdFusion (feel free to laugh) 8 site that that is hosted in a shared environment. The database and the web server are separate boxes. We don't have root access to either, and we don't have "exec xp_cmdshell" permission. SQL Server version is 2005. </p>
  
  <p>So, what is the closest equivalent to BULK INSERT that we should try if we would like to efficiently import a CSV or other text file into the database--but without BCP or "format files"? </p>
  
  <p>Obviously, we could just build a massive INSERT statement in ColdFusion, with UNION ALLs for each row, and run that. But is that the best option? Your thoughts?</p>