var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Catastrophic failure in Microsoft Data Transformation Services
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.
Can you post the create table statement of the destination table?
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.