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

avatar image

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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Dec 04, 2009 at 05:37 AM

Seen: 3001 times

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

Copyright 2018 Redgate Software. Privacy Policy