I am having some problem creating a new DTS task or modifying an existing
one. My goal is to transfer data from a table (tableX) to a text file
(export.txt). I can not define the columns I want to transfer in the
Destination tab under the Transfer Data Task Properties. If I use the Define
Columns… button, Enterprise Manager crashes. If I try to define the columns
manually, I get the following message:

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

Please help.

Thanks