question

dariusj18 avatar image
dariusj18 asked

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?

insertimport-databulk
1 comment
10 |1200 characters needed characters left characters exceeded

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

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 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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