Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009

    Unanswered: Catastrophic failure in Microsoft Data Transformation Services

    Hi there,

    I tried to import an HTML file using Microsoft DTS. However there is an error with the following details:

    Step Error Source: Microsoft Data Transformation Services (DTS) Package
    Step Error Description:Catastrophic failure
    (Microsoft Data Transformation Services (DTS) Package (8000ffff): Catastrophic failure
    Step Error code: 8000FFFF
    Step Error Help File:sqldts80.hlp
    Step Error Help Context ID:1100

    Seems like it is the file size of the HTML file that caused this problem. Any html file with size of 4,096 bytes will face this problem.

    Appreciate if anyone can help on this. Thanks.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Can you post the create table statement of the destination table?
    Home | Blog

  3. #3
    Join Date
    Mar 2009
    Hi gvee,

    The issue is not during the creation of the table. The error message appears the moment you try to import the HTML file as a source. I have attached the screenshot of the error message and also the zipped html file.
    Attached Thumbnails Attached Thumbnails error.gif  
    Attached Files Attached Files

Posting Permissions

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