BULK INSERT Using CLOB/VARCHAR(MAX) Data?

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?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RBarryYoung commented · Dec 06, 2009 at 12:48 AM

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.

0 ·

question