DTS Error

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 column
s
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.
ThanksHi
If you are only wanting to transfer a subset of the source tables columns
then you will need to restrict the columns in the source by specifying a SQL
query that selects the columns that your require.
John
"Emma" <Emma@.discussions.microsoft.com> wrote in message
news:088B07FA-328C-469A-A9D4-83C0A6730FE9@.microsoft.com...
>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
>