I need a way to allow end users to import data into a table from a CSV file, containing many, many possible records. Ideally the process would allow the user to go through a process similar to SSIS's import wizard, allowing them to upload the file, then select the columns they wish to map. I'm trying to create an easy process through a web interface which someone who is not a DBA can perform.
The issue is that most of the time the SQL Server/Web Sever is not an environment that I have much control over. I had an idea that being able to use the BULK INSERT command but using CLOB data from the database (since I can't write the file to the SQL Server's file system, as far as I know).
I am constrained to using Coldfusion as my server side language.
Is there any way of doing this? Are there any suggestions as to other ways this can be done?