dbTalk Databases Forums  

Multi-Phase Data Pump Error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Multi-Phase Data Pump Error in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
smsradius
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.