BUG: Test Button Fails if DTS Transform Has No Destination Columns

ID: Q247108

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 54907 (SQLBUG_70)

SYMPTOMS

In the ActiveX Script Transformation Properties dialog box of the DTS Designer, an attempt to test a Transform that does not have any destination columns fails with the following error:

Incomplete file format information - file cannot be opened.

The actual error message is returned within a message box after double-clicking on the failed 'DTS Testing Transform Task' step.

The same behavior can be observed by right-clicking the Transform through the Data Transformation Properties dialog box and then selecting the Test (CTRL+T) option.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: DTS Transform Transformation Task Error

Keywords : kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug