|
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?
(comments are locked)
|
What's the User to SQL Server network configuration? LAN, WAN or Internet? What's the end-to-end application bandwidth? There's no point to worrying abount BULK INSERT or CLOB's etc., until you know this because the Network performance issues are likely to be dominant.