Post reply

Table Load from DTS

  • March 24, 2005 at 8:45 am

    #61540

    Hello All,

    I have a SQL DTS Package that load a table from a text file. Currently if there is a record that is not correct, the package will dump it out into an exception file. Is there a way to drop that exception record into a different table instead? All DTS will allow is to dump it out to a text file. I would like to keep it in the database, and then use an ASP page to view that table, also, I cna set a trigger on the insert and fire off an email stating that there is now an exception record

    Thanks

    Andrew

  • March 24, 2005 at 2:07 pm

    #548851

    Andrew,

    I would add another ActiveXScript that opens the exception file and loads it into a table. I would also handle the email from this script (I don't like having triggers handle that kind of process, just a personal thing :blink.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply