I agree with Chad. ASP is a horrible suggestion for this problem.

DTS is the best choice. It won't take you more than a couple of minutes to
set up an import process of a CSV file.

-----Original Message-----
From: Thomas, Chad [mailto:[Email Address Removed]
Sent: Thursday, October 09, 2003 2:36 PM
To: LazyDBA.com Discussion
Subject: RE: Automatically importing CSV into SQL table

Why would you recommend running this from an ASP page? It makes no
sense. First off I would never recommend running IIS on a production
SQL server, I have seen to many servers choke from dumb programmers
using on error resume next on an errored out SQL statement, poof there
went your SQL server. This is the exact scenario that DTS was created
to do. It merely involves one object. An ASP page to do this is a bad,
bad idea.

-----Original Message-----
From: Sandeep Kataria [mailto:[Email Address Removed]
Sent: Thursday, October 09, 2003 4:15 PM
To: LazyDBA.com Discussion
Subject: Automatically importing CSV into SQL table

try something like this....from an ASP web page. Quite easy to use
access/vb
to do this too. No DTS required this way. Hope it helps....

Sandeep

******************************************************
Sandeep Kataria
University of Minnesota Cancer Center,
Suite 310 Dinnaken Office Building,
925 Delaware St. SE
Telephone: (612) 624-3994 | Fax: (612) 624 1057
Email: [Email Address Removed]
******************************************************
PRIVACY & CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s) and may
contain business confidential and privileged information. Any
unauthorized
review, use, disclosure or distribution is prohibited. If this e-mail
was
not intended for you, please notify the sender by reply e-mail that you
received this in error. Destroy all copies of the original message and
attachments.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page