Multi-Phase Data Pump Error -
03-08-2005
, 01:20 PM
I get this error when I try to execute a package that runs fine in test
mode:
A DTSTransformCopy must specify no columns (signifying a sequential
1-to-1 mapping of all columns) or the same number of source and
destination columns.
Despite this instructional text suggesting otherwise:
Use scripting code supported by an installed scripting engine to write
your own transformations. Many transformation mapping configurations
are possible when using ActiveX scripts, including equal or unequal
numbers of source and destination columns, source columns and no
destination columns, destination columns and no source columns, and
neither source nor destination columns. In mappings without source or
destination columns, data from global variables or lookup queries is
usually processed.
I have an unequal number of source and destination columns. What can I
do to make DTS ignore the unequal number of columns?
Thanks.
Christian |