I am having problems modifying an existing DTS package and crating a new one
to transfer data to a text file.

When I open an existing package to modify it, and click on the
transformation tab, I get a window stating that says “Some of your
transformations refer to columns that do not exist in your source or
destination.” With the following options: Remove invalid transformations,
Change source/destination, Remove all transformations and redo auto-mapping.

When I select any of the options, I am prompted to redefine the
transformation. Under the transformation options when trying to modify an
existing one or create a new one, I am able to select source columns but
there is no column to select under destination column.

When I tried to create a new transformation to export the data to a text
file, I am able to select the source table. When I click on the destination
tab, I am prompted to define the columns for the destination. After defining
the columns and I click on Execute, nothing happens.

These are the two error messages that I get:

DTS Designer Error: To continue, define transformations. You can make
changes to the default transformations.

DTS Designer Error: An error occurred when you tried to submit changes to
this transform. Please refer to the following error message and make sure
that you have edited other properties of this transform by pressing
“Properties” button on the “General” tab.
Error Source: Microsoft Data Transformation Services (DTS) Data Pump

Error Description: A DTSTransormCopy must specify no columns (signifying a
sequential 1-to-1 mapping of all columns) or the same number of source and
destination columns.

How do I make sure that the destination columns are being defined and what
am I doing wrong.

Thanks
Emma