File Import Error Handling ?

Results 1 to 2 of 2

Thread: File Import Error Handling ?

  1. #1
    Join Date
    Dec 1969

    Default File Import Error Handling ?

    I import Tab Delimited file of 100+ lines thru ASP into SQL server everyday. Sometimes these files have problem in one of the lines. When i encounter problem, how do i tell the user the line number and also undo(rollback) the import, so the user can fix the file and import again.<BR><BR>I am reading one line at a time and writing into sql using addnew method of recordset.<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default You have to use transactions... allow for a rollback. Check out the documentation or Microsoft&#039;s website for information.<BR><BR>Telling the user about the problems can be done in various ways. The simplest one would be to do a Response.Write, so that the user calling the ASP page can see what&#039;s happening. It depends on your set up really.<BR><BR>Oliver.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts