BPC 7.0 MS-Transformation File Error Duplicated Signeddata

112 Views

Hi,

I tested this transformation file on BPC 5.1, and it was able to load data with out error. When the client moved to 7.0. I received the following error:

Convert Data

Success

Record Count : 11212

Accept Count : 11212

Reject Count : 0

Skip Count : 0

Duplicate column name 'SIGNEDDATA'.

-

Here is a copy of the transformation file:

*OPTIONS

FORMAT = DELIMITED

HEADER = NO

DELIMITER = ,

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=-1

ROUNDAMOUNT=

*MAPPING

ACCOUNT=*Col(1)

CATEGORY=*Col(2)

ProfitCenter=*Col(3)

ENTITY=*Col(4)

TIME=*Col(5)

SIGNEDDATA=*Col(6)

DATASRC=*NEWCOL(TESTFile)

Measures=*NewCOL(Periodic)

*CONVERSION

-

I tried taking out the SignedData line in the transformation file, and this is the error I received:

Convert Data

Success

Record Count : 11212

Accept Count : 11212

Reject Count : 0

Skip Count : 0

The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (8004202c): TransformCopy 'DTSTransformation__7' conversion error: General conversion failure on column pair 1 (source column 'SIGNEDDATA' (DBTYPE_STR), destination column 'SIGNEDDATA' (DBTYPE_NUMERIC)).)

Any help will be apprecated!

Thanks,

Mark