Bulk Insert to SQL Server from ASP.NET

[planetmatt]

I need to create a page that bulk inserts a CSV text file into SQL
Server. I have plenty of experience with SQL Server and have built
some web apps with classic ASP but have never used ASP.NET before.

I have got as far as getting the text file from the workstation
uploaded to the webserver and now I need to execute a bulk insert to
load the file into a temporay table before calling a SP that I've
already written to process and import the data to production tables.

Can anyone point me in the right direction regarding getting ASP.NET to
do a bulk insert. I'm using VB as my ASP language.

Thanks

 

[sloan]

Check out:
http://support.microsoft.com/kb/315968

and

http://www.sqlservercentral.com/columnists/sholliday/thezerotonparameterproblem.asp

the second article would be to understand how better to use OPENXML inside
the stored procedure.

Once you have data in a @variable or #temp table (in sql server) you can do
anything you want with the data.