Hi,

Somehow I got the impression that he does not want to use DTS, why I cannot
imagine, so the alternative of ASP, VB, Access etc.....

I think I know enough about ASP to know the pitfalls and I agree it is not
the best of tools.....

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.

-----Original Message-----
From: Thomas, Chad [mailto:[Email Address Removed]
Sent: Thursday, October 09, 2003 4: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