DTS from table to text delimited file
Posted on 2004-04-27
I am trying to DTS from a sql server 2000 table to a | delimited text file.
I can get it to work fine with all the columns, but if I try and exclude some of the columns it comes up with the following error:
A DTSTransformCopy must specify no columns (signifying a 1-to-1 mapping of all columns) or the same number of source and desgination columns
However - the destination columns section is empty.
anyone got any ideas?