x

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?

more ▼

asked Dec 04, 2009 at 05:37 AM in Default

dariusj18 gravatar image

dariusj18
21 1 1 1

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.
Dec 06, 2009 at 12:48 AM RBarryYoung
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x107
x66
x10

asked: Dec 04, 2009 at 05:37 AM

Seen: 2454 times

Last Updated: Dec 04, 2009 at 05:37 AM